Searching a site.

[Nuwanda]

Hello I was wondering if anyone had any tips on how i go about making a group of products searchable by make, price and type on a webpage. Say I had 40 cameras and I wanted the visitor to be able to refine the search, using dropdowns, to the price range, type of camera, and manufacturer of just those they were interested in.

Thanks

 

[louie]

Just query the database if there is one.

 

[Dotwebs]

Your query would look something like this - change the database name to yours and variables to yours:

SELECT * FROM databasename WHERE make = '' AND price = '' AND type = ''

If your search is too defined you can return more results by using OR instead of AND.

 

[Forbairt]

you probably want to change the last bit database name to your table name.

 

[Dotwebs]

you probably want to change the last bit database name to your table name.

Oh yea -

SELECT * FROM tablename WHERE make = '' AND price = '' AND type = ''

 

[Nuwanda]

Thanks very much for the help!