Why does my Query doesn't work?

[rhyancute]

hello good day to all..

i have problem here and i know any one here can solve this:

Code: [Select]

$query=mysql_query("SELECT * FROM tbl1 WHERE id NOT IN (SELECT id FROM tbl2) && fld1!='resign' || fld1!='awol' ORDER BY $id",$conn);
thanks in advance

[Zyppora]

Are you getting any errors, or does it have unexpected results (if so, what were you expecting, and what it is returning)?

[rhyancute]

i got it.. tnx :d