SELECT statement with and OR

ihenman

I don't know if this is even possible. I am trying too do a SELECT statement but need two check two values for whether the row should be included..

Something like this

SELECT * from table where item=X OR item2=y

So if item=x it will include the row and if item2=y it selects the row even if item does not = x.

Sorry if this sounds confusing...basically I want too perform something similar too an IF statement within my select can it be done? If not what is a similar way I can perform this using only one select statement.

THX!

drew010

that query you put there should work just fine. you can use or's and and's and not's in your queries.

http://dev.mysql.com/doc/mysql/en/Logical_Operators.html
http://dev.mysql.com/doc/mysql/en/SELECT.html

ihenman

Great I was unaware of that....I read over the SELECT portion of the MYsql Manual...

So I should be able too use this then

$sql = "SELECT * from table where id = '$item' and site = '1' or page = '5'":

Does that make sense?? I'll try it out anyways! Thanks

drew010

yeah looks good. if it doesnt quite do what you want, try paranthesis around site = '1' or page = '5' depending on how you want the whole boolean logic to be processed.