[RESOLVED] Multiple Variables in query

[plapeyre]

This works fine:

$developer_query = mysql_query("SELECT * FROM accounts WHERE level<='2'");

However, that will include all information in table.level 0, 1, 2 ... i want to EXCLUDE 1 ... i have tried:

$developer_query = mysql_query("SELECT * FROM accounts WHERE level='2' AND level='0'");

however, we all know that that wont work... how can i make it so it only select 0 and 2, without having to run multiple strings? thanks 😉

Phill

[stiduck]

Try this:

$developer_query = mysql_query("SELECT * FROM accounts WHERE NOT level='1'");

stiduck

[plapeyre]

yes that worked, but i stuffed up my post! ahaha
there are actually, 0, 1, 2, 3 and i only want to display 0 and 2 ...
sorry

any other suggestions?

[plapeyre]

 $developer_query = mysql_query("SELECT * FROM accounts WHERE level<='2' AND NOT level='1'");

Illiminates 3

WHERE level<='2'

Illiminates 1

NOT level='1'

Output:
results from 0 and 2 only

thankyou for your assistance 🙂