SQL SELECT statement help

Anon

Hi guys,

I am having trouble with the following SELECT statement using MySQL:

$sql = "SELECT * FROM products WHERE picture IS NOT NULL AND WHERE cat_id='405' OR cat_id='416' OR cat_id='418' OR cat_id='420' OR cat_id='430' OR cat_id='440' OR cat_id='510' OR cat_id='580' OR cat_id='605' OR cat_id='730' OR cat_id='792' ORDER BY rand() LIMIT 4";

Basically, it ignores the IS NOT NULL statement and sends me all the results, but I really just want the results where there is something in the picture column and also from one of those categories.

any ideas?

Thanks,
Zac

Anon

I believe you just need to put paranthesis around the or statments, like:
where name = 'whatever' and (somethingelse = 'something' OR somethingmore = 'more')
etc. Hope it helps, please e-mail me if it does.

Anon

Mike,

Thanks for the suggestion...I had tried that but to know avail. To me, everything looks great, however, I am still getting results that have nothing in the 'picture' column. I am using IS NOT NULL as in the MySQL documentation and I am getting no errors, however, it seems to be ignoring or couteracting that statement. Any further ideas would be very appreciated! Here is the current code:

$sql = "SELECT * FROM products WHERE picture IS NOT NULL AND (cat_id='405' OR cat_id='416' OR cat_id='418' OR cat_id='420' OR cat_id='430' OR
cat_id='440' OR cat_id='510' OR cat_id='580' OR cat_id='605' OR cat_id='730' OR cat_id='792') ORDER BY rand() LIMIT 4";

amcgrath

Your statement is wrong: reword this way:

SELECT * FROM products WHERE picture IS NOT NULL AND cat_id in (418,416,etc...) order by rand() limit 4

ace21

Something to think about is that if you insert a blank '' into picture that is not considered NULL. Instead it is considered ''. That is in your statement you would have where (picture is not null and picture<>'') then your catis statement.

Ace21