Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: mack
I need a user on my site to be able to fill in 2 fields on my site and if they match, return a third field.
basically it would be their Last Name and Zip code, if this matched it would show the expiration date of their membership.
the database would just be the 3 fields and maybe 2000 records.
I just don't know where to start on this.
my webhost has MySql, PHP, etc.
(note: this is related to a club membership that is not web-based, people get a magazine and want to have a simple way to find out when it expires. Right now they send emails or call me even though it is actually printed on their magazine)
Next you need to setup a table in your database. Refer here: create table syntax [dev.mysql.com]. If you have phpmyadmin this process is easier.
After that you need to know how to 'talk' to mysql with php. For that, we have a few great threads in the php forum library that should get you moving along. Here are a few:
basics of extracting data from mysql [webmasterworld.com]
commonly used mysql commands [webmasterworld.com]
And don't forget to check the documentation at php.net and mysql.com. That shold get you started.
Happy coding ;)
That's like using a Ferrari to ferry the children one mile to school, very expensive, and excessive.
You can just use a simple text flat file, one record per line and separate the fields with a simple delimiter. Very fast, very simple.
I only mentioned that MySql and PHP are installed on my webserver in case anyone asked. If I can avoid using MySQL, that would be great.
I just use that for the premade forum and photoposting programs that I installed. All the heavy lifting is done.
I will look at the "Dealing with Forms" link, thank you.
I am viewing this as a learning experience so I plan to start *very* small and work my work my way up. Its a hobby job, not a work job.