Trying to pull all the records from mysql where a field is null. This isn't working and neither is anything else I try. Any ideas? This just give me a blank record.
mysql_query("SELECT * FROM dbUser WHERE name = '' ",$db);
Try this:
mysql_query("SELECT * FROM dbUser WHERE name is null,$db);
You can't just use an empty string, you have to use the is null keywords that are in mysql and sql similarly.
Hope this helps, Jim
