form boxs example, pulldown and input box
from my below code the database gets searched via the name and the word name comes from the varable name in the form input box,
so if you had lots of search features how do you add them example.
do you just add afther the WHERE clause other AND that relate to the input form name or the pulldown option name this is to save on querys or do you add lots and lots of querys.
example for 2 input boxs and 1 pulldown box
WHERE fname = '%"fname"%' AND address='%"address"%' AND price='%"price"'
seach example for 1 input box
//connect to database for data result useing like and %wildcard for name search $db=mysql_connect("localhost","xxxx","xxxx"); mysql_select_db("xxxx" , $db); $query="select pro_membersu.fname , pro_membersu.birthday , pro_membersu.email from pro_membersu where fname like '%".$name."%'"; $result=mysql_query($query);