dynamic query to MySQL database

[Anon]

Hello. I am new to the PHP world and need some help. I need to create a page where a user can create a query based on the available fields and a list of conditions. I am not sure how to write the PHP code to do this. I am assuming that I can create a form with drop down boxes where the user can select the fields to query but how to get those fields into a php form to run the query is my problem. Any help is much appreciated. Thanks Susan

[bastien]

simple really...pass the form back to the server and create the SQL string by taking the form variables and plugging them in. It will get a little trickier if you are using dopdowns with multiple selects (more than one option can be chosen) but the basic one is:

$SQLGetData = 'select ' & $fname & ',' & $lname & 'from myTable'

where $fname and $lname are the dropdowns values...

Basically you just need to concatenate the values to the SQL string and then execute...
hth
Bastien