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