Advice on search feature

[graham23s]

Hi Guys,

 

i have my search feature working great , you can search various firlds male or female etc and it brings back results, what i'm not to sure of is how to "Search All" either male or female for example the code for that is:

 

  echo ("<tr>");
  echo ("<td colspan=\"2\" class=\"header_boxes\" align=\"left\"><span class=\"prof_head\">Search My Live Audition - [Full Search]</span></td>");
  echo ("</tr>");
  echo ("<td class=\"sub_table\" align=\"right\"><b>I'm looking for a</b></td><td class=\"sub_table\" align=\"left\"><select name=\"gender\"><option value=\"0\">-- Search All --</option>");
  echo ("<option value=\"M\">Male</option><option value=\"F\">Female</option></select>");
  echo ("</td>");

 

just basic html really, it give the GET either a M or F to search in mysql with, i have given the search all a default of 0, but im lost as to what to do with it in regards to searching

 

any advice would be great

 

cheers guys

 

Graham