2 AND commands?

[liamloveslearning]

Hi all,

I need to query my database where x is y and where x is also z if this makes sense?

 

My query is something similiar to...  SELECT * FROM 'x' WHERE x=x AND model_pictures.theme=1  AND model_pictures.theme=3 only it isnt working, Is it possible to have somthing like..

 

AND model_pictures.theme=3 AND 1?

[Adam]

Your problem is not with the where clause, but SELECT * FROM 'x'. You cannot have quotes around a table name, you need to use grave accents ``.

[liamloveslearning]

Sorry MrAdam. that was a typo I was just quickly typing x=x for an example.

[Adam]

Okay, could you paste the actual SQL you're trying then?

[PFMaBiSmAd]

model_pictures.theme=1  AND model_pictures.theme=3

 

A column can only have a single value at any time. ^^^ Using AND there won't match anything because the value cannot be both 1 and 3 at the same time. You need to use OR to form a union/set of rows that have the values 1 OR 3.

[liamloveslearning]

nvm didnt realise there was an OR clause!

[liamloveslearning]

My query is

SELECT model_login.id, model_login.username, model_pictures.id, model_pictures.user_id, model_pictures.user_picture, model_pictures.user_picture_date, model_pictures.user_pic_approval FROM model_pictures, model_login WHERE model_pictures.user_id=model_login.id  AND model_pictures.user_pic_approval=1  AND model_pictures.theme=1 OR model_pictures.theme=3

 

Does this seem valid ?

[Adam]

You need to wrap model_pictures.theme=1 OR model_pictures.theme=3 within parentheses, so that it will match all the rest and then either one of those two.

[dix.selken]

hello

 

I recommend you to use in clause instead of several or clause

 

select * from phones where brand in ('sony ericsson','panasonic','lg')

 

works the same like

select * from phones where brand = 'sony ericsson' or brand='panasonic' or brand = 'lg'

 

see ya