[SOLVED] SELECT AND error

[forumnz]

My code should select * from a db where something = something AND something LIKE....

 

Anyway, it basically ignore the addre as below:

 

What could be wrong?

 

$query = "SELECT * FROM cmads WHERE addre='5' AND keyw LIKE '%$trimmed%' OR buzzname LIKE '%$trimmed%' OR descr LIKE '%$trimmed%' OR sub LIKE '%$trimmed%'
  ORDER BY keyw"; 

 

Thanks,

Sam.

[hitman6003]

[code]Use parenthesis:
[code]
SELECT * 
FROM cmads 
WHERE addre='5' AND 
  ( keyw LIKE '%$trimmed%' OR 
    buzzname LIKE '%$trimmed%' OR 
    descr LIKE '%$trimmed%' OR 
    sub LIKE '%$trimmed%'
  )
ORDER BY keyw

 

You will get dramatically different results depending on how you use them[/code][/code]

[forumnz]

THANKS!!

[redarrow]

try it this way ok.

 

let me no if it works atleast cheers.

 

<?php 
$query = "SELECT * FROM cmads
WHERE addre='5' AND keyw 
LIKE '%".$trimmed."%' OR buzzname LIKE '%".$trimmed."%'
  OR descr LIKE '%".$trimmed."%' OR sub LIKE '%".$trimmed."%'
  ORDER BY keyw"; 
?>