help,i'm lost

[lturton]

i've got this web page which can search by one category, but i need it to search by at 3, there are 3 text fields taking info and a submit button, results must be shown on the same page help

[Charter]

In the script, after you clean/slash the form variables, edit the query so it has something like the following in it:

SELECT var1,var2,var3 FROM table WHERE var1 LIKE '%$var1%' OR var2 LIKE '%$var2%' OR var3 LIKE '%$var3%'

Then in the mysql_fetch_array part of the code, edit it for the new variables. There are some examples here (http://www.php.net/manual/en/function.mysql-fetch-array.php).

[ruchit]

TIP: avoid using mysql_fetch_array.. it is slower than both mysql_fetch_row & mysql_fetch_assoc