[SOLVED] Mysql syntax

[dhimok]

Hi everyone.

 

I want to select from a table where id = querystring and status = 1 and amount is either greater then 0 or like 'unlimited'

 

I tried to use this syntax

 

$result = dbQuery("SELECT * FROM tbl WHERE category_id = '".$cat."' 
	AND status = '1' AND amount > 0 OR amount LIKE '%unlimited%'  
	ORDER BY sort_order ASC");

 

If i use  LIKE '%unlimited%' i get the results repeating themselves. So its not working.

Any help on how to get all params

 

Thanks

 

[btherl]

When you mix AND and OR, you should use brackets to make it clear what you want.  Eg

 

WHERE category_id = '".$cat."' 
	AND status = '1' AND ( amount > 0 OR amount LIKE '%unlimited%' )

 

Is amount a text string that can also hold numbers?

[dhimok]

Thanks, I think it works now