Hi,
If anyone could help that would be great. I have a database with 1 user table with values such as name, age, location, experience
What I am looking to do, is create an html page with a number of dropdown boxes where the user can select from those boxes, a predefined option for each category. E.g. when the user selects age, they have the options of choosing 20-22, 23-25,26-28 etc.
I then need help building a php script which will allow me to search the table using any of the drop down boxes to filter the results, so if for location for example they choose england, it will display all users who live in england, and if they select location=england and age=20 to 22, then they are able filter the results based on those two options.
Any help would be much appreciated, even if it is a link to a tutorial - but it needs to be quite comprehensive - i'm not that great at php! Also, I have searched google, so it's really a question for someone who knows what they're talking about!
Thanks for the first post. That however looks at selecting different tables. I just need to search values from each column in one table as mentioned above.
If anyone could help that would be great. I have a database with 1 user table with values such as name, age, location, experience
What I am looking to do, is create an html page with a number of dropdown boxes where the user can select from those boxes, a predefined option for each category. E.g. when the user selects age, they have the options of choosing 20-22, 23-25,26-28 etc.
I then need help building a php script which will allow me to search the table using any of the drop down boxes to filter the results, so if for location for example they choose england, it will display all users who live in england, and if they select location=england and age=20 to 22, then they are able filter the results based on those two options.
Any help would be much appreciated, even if it is a link to a tutorial - but it needs to be quite comprehensive - i'm not that great at php! Also, I have searched google, so it's really a question for someone who knows what they're talking about!
Thanks for the first post. That however looks at selecting different tables. I just need to search values from each column in one table as mentioned above.