Search form sql

[stuieb]

Hi,

 

I have a search form on a page that has three select fields.

 

make

 

location

 

price

 

Each is dynamicly generated from information in the database.

 

The form gos to a results page (GET) and displays the results.

 

The problem I am having is with the MySQL SELECT on the results page. Basicly I want the user to be able to search for all records from 'make' from within the table, or all records from 'location' or all records from 'price' or by a combination of all three. Make, location and price are all cols in a table bye the way.

 

Please help!

 

Stu.