MySQL SELECT Question...

[Anon]

If I am doing a select statement where I want to grab data from the same table where var1=0 and var2=1 how would I construct this?

I don't want an AND statement because that returns all instances of var1=0 and all instances of var2=1. Rather I want all instances of var1=0 when var2=1.

== AND statment (incorrect)==
SELECT * FROM $table WHERE sendprinted='1' AND newslabel='0'

Would I use a limit or just make 2 queries?

Thanks for any help.

Chris Chaudruc

[Anon]

how about 'OR'?

SELECT * FROM $table WHERE sendprinted='1' OR newslabel='0'