Mysql query

[zero_ZX]

Hello,

I have a query where i try to search, but i want to put a limitation, but it doesn't seems to be working :/

Here's my code:

$result = mysql_query("SELECT * FROM clients WHERE staff = 0 AND username LIKE '%" . $keyword .  "%' OR company LIKE '%" . $keyword .  "%' ORcontact LIKE '%" . $keyword .  "%' OR address LIKE '%" . $keyword .  "%' OR email LIKE '%" . $keyword .  "%' OR phone LIKE '%" . $keyword .  "%' ORDER BY phone");

 

Alright, so i basically want the user to search in all of those fields, however i want it to filter all "staff" members, so it should only view the "0" ones, meaning the clients, only problem that when i run this, all clients gets displayed, also the staff accounts.

 

Any suggestion?

[PFMaBiSmAd]

If you want a specific value AND any of the other values, you must () to indicate that's what you want -

"SELECT * FROM clients WHERE staff = 0 AND (username LIKE '%" . $keyword .  "%' OR company LIKE '%" . $keyword .  "%' OR contact LIKE '%" . $keyword .  "%' OR address LIKE '%" . $keyword .  "%' OR email LIKE '%" . $keyword .  "%' OR phone LIKE '%" . $keyword .  "%' ORDER BY phone)"

[zero_ZX]

Oh ya that's right, thanks a lot!

Remember that order by shouldn't be, so the final code would be

"SELECT * FROM clients WHERE staff = 0 AND (username LIKE '%" . $keyword .  "%' OR company LIKE '%" . $keyword .  "%' OR contact LIKE '%" . $keyword .  "%' OR address LIKE '%" . $keyword .  "%' OR email LIKE '%" . $keyword .  "%' OR phone LIKE '%" . $keyword .  "%') ORDER BY phone"