Sql Where & And

[aspect]

Quick question :

How do you query using TWO or more WHERE parts?

I thought it would be summin like this (using AND)

"SELECT * FROM users WHERE id>0 AND active='true"

Thanks in advance

[Sharif]

Are you trying to create a query where the user id is bigger than zero and active field has a value of true?

Try this:

SELECT * FROM users WHERE id != 0 AND active = 'true'

[aspect]

so the correct syntax for using TWO WHERE arguments is definatly AND then.....

Thanks m8 thats all i needed to know..

The problem must be somewhere else then... cheerz

[Roger_Ramjet]

Just a point, is the active field a char filed that stores the word TRUE? Because that is what your query asks.