search page, php/mysql

[Anon]

Hi, I'm having difficulties executing a search page with PHP and MySQL. I want the user to be able to search on his/her desired fields and then query the database accordingly. I've found numerous examples to query the database when the user types info into one field, but how can I get it to work for only the fields that the user types criteria into?

Thanks, any suggestions would be greatly appreciated.

[Anon]

The way i would do it is:

$sql = "SELECT * FROM table_name WHERE ";

if(!empty($FormField1))
{
$sql .= " table_column = '$FormField1' ";
}

if(!empty($FormField2))
{
$sql .= " || table_column = '$FormField2' ";
}
...

Basically, you use php to build a query for you. What is included in the query depends on the fields that user filled in.

Richie

http://geocities.com/akindele/