mysql retrieving
Posted: Thu Jan 14, 2010 3:24 pm
Hi, I'm new to php and I want to write a script that can look in a mysql database and search for different criteria depending on the input from an HTML form. for example, I would have a HTML page that asks the user (via a HTML form) different questions, and then submits (or posts) the info to a php file which looks in the mysql database. The mysql database would contain different ski resorts (because that is what the website will be about) and the php file will show resorts that are good for skiing with a family for a complete beginner (or whatever else the user selects). The resorts in the mysql database may also turn up for more than one search. eg. a resort named "test" may turn up if the user selects the options shown in the picture below, or if the select the same options in the picture except the level, which could be 2 also. Then I want the php file to show a list of resorts from the mysql file suitable for the user that submitted the form.
The html form would look something like this:

Any help would be greatly appreciated
The html form would look something like this:

Any help would be greatly appreciated