Page 1 of 1

IS NOT NULL not working

Posted: Sun Jan 04, 2009 11:09 am
by Da_Elf
$sqluser = "SELECT * FROM User Where Accepted='1' AND WHERE UserFName IS NOT NULL ORDER BY UserFName ";

Ok. whats wrong with this. i keep getting an error

Re: IS NOT NULL not working

Posted: Sun Jan 04, 2009 11:40 am
by msurabbott
You only need one 'WHERE' clause, your query should look like this:

Code: Select all

$sqluser = "SELECT * FROM User WHERE Accepted='1' AND UserFName IS NOT NULL ORDER BY UserFName ";

Re: IS NOT NULL not working

Posted: Sun Jan 04, 2009 11:49 am
by Da_Elf
ah thanks