Search using drop down list

hello guys,

i need some help regarding search by on my website. here is my point, i have a field and a drop down. i choose, lets say product name in the drop down and insert the name to search. this works great. even the picture is displayed. i want to add brand to the drop down list so that i have 2 options. how do i do the search when the brand option is selected in the drop down. i need a tutorial regarding that? mysql table to be queried....

how about you write the code yourself rather than copying and pasting it from some tutorial?

Since the general search logic seems to work already, it shouldn't be too hard to add an if statement to the PHP code, which distinguishes between the different options and changes the query accordingly.

If you want concrete advice, we need to see your current code (not all of it, just the relevant parts).

Why canít I use certain words like "drop" as part of my Security Question answers?
There are certain words used by hackers to try to gain access to systems and manipulate data; therefore, the following words are restricted: "select," "delete," "update," "insert," "drop" and "null".

//This counts the number or results - and if there wasn't any it gives them a little message explaining that
$anymatches=mysql_num_rows($data);
if ($anymatches == 0)
{
echo "Sorry, but we can not find an entry to match your query...<br><br>";
}

//And we remind them what they searched for
echo "<b>Searched For:</b> " .$find;
//}
?>