mysql database - email type?

[Anon]

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.

[Anon]

mysql> describe replies;
+---------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+----------------+
| id | int(11) | | PRI | 0 | auto_increment |
| email | varchar(50) | YES | |
+---------+-------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)

mysql> SELECT email FROM replies WHERE email IS NOT NULL;

//-------selects perfectly here, not showing null fields

try it at the mysql prompt, perhaps?

[Anon]

Does the exact same thing under the mysql prompt.

describe replies,

email | varchar(50) | YES | null