[RESOLVED] mysql select

vang

Hi,
i have a search box and the search box works fine with this code.

$sql = "SELECT * FROM table
		  WHERE studentid like '%$searchbox%'
			OR fname like '%$searchbox%'
			OR lname like '%$searchbox%' ";

Now i want to add 2 more drop down box to filter the column data.

$sql = "SELECT * FROM table
		  WHERE studentid like '%$searchbox%'
			OR fname like '%$searchbox%'
			OR lname like '%$searchbox%'
			AND fname = '$selectbox2'
			AND lname = '$selectbox3' ";

But I 'm having problem with the above code.
Your help is greatly appreciated, thanks.

NogDog

AND has a higher precedence than OR, so if I'm correctly guessing the logic you want, you probably need to group the ORs together:

$sql = "
SELECT * FROM table
   WHERE 
      (
         studentid like '%$searchbox%'
         OR fname like '%$searchbox%'
         OR lname like '%$searchbox%'
      )
      AND fname = '$selectbox2'
      AND lname = '$selectbox3'
";

bradgrafelman

Then again, in your example, the query can be reduced to:

$sql = " 
SELECT * FROM table 
   WHERE 
      studentid like '&#37;$searchbox%' 
      AND fname = '$selectbox2' 
      AND lname = '$selectbox3' 
";

vang

Dear all,
many thanks for your guidance. I left out the drop down box since the search box is suppose to have search the whole table and it will be pointless to have drop down box in this case.
Thanks.