[SOLVED] Can you use OR in mysql query? if so, how do you use it?

[ted_chou12]

Can anyone suggest me, give me an example with the use of OR in mysql query?
Thanks
Ted

[trq]

[code]SELECT foo FROM bar WHERE foo = 'bob' OR foo = 'boo';[/code]

or

[code]SELECT foo FROM bar WHERE foo = 'bob' || foo = 'boo';[/code]

[ted_chou12]

I tried this:
$query_count = "SELECT * FROM friendlist WHERE username='$username' AND status='pending' OR status='declined'"

and it doesnt work, is it because of the way i organised it?
Ted

[ted_chou12]

sorry, my bad... i think it works...
Ted

[trq]

You should group it within braces.

[code]$query_count = "SELECT * FROM friendlist WHERE username='$username' AND (status='pending' OR status='declined')";[/code]

[ted_chou12]

Thanks  ;D