I know the answer must be staring me in the face, but I've been pulling my hair out over this one. I'm trying to :
$result = mysql_query("SELECT email FROM members WHERE email IS NOT NULL");
I want to list all email addresses in the column 'email'. The problem is, it's showing all email's and all empty fields as well.
email is set up in the database as a varchar.
Thanks for the help.
$result = mysql_query("SELECT email FROM members WHERE email IS NOT NULL");
I want to list all email addresses in the column 'email'. The problem is, it's showing all email's and all empty fields as well.
email is set up in the database as a varchar.
Thanks for the help.