$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
IS NOT NULL not working
Moderator: General Moderators
-
msurabbott
- Forum Commoner
- Posts: 33
- Joined: Thu Jan 01, 2009 10:18 pm
- Location: Chicago, IL, USA
Re: IS NOT NULL not working
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
ah thanks