Re: [PHP] Getting email out of a database

how about grabbing the first result out of the 'while'??? something like: list($var1) = mysql_fetch_row($result); while( list($email) = mysql_fetch_row($result) ) $var2[] = $email; hope this helps... At 11:04 19/5/2001 -0700, Richard Kurth wrote: > I am trying to pull all the e-mail

[PHP] Getting email out of a database

I am trying to pull all the e-mail address out of a database to be able to do a mass send. This gets me all the e-mail address and puts a , between them which is what I want. $sql = "SELECT CONCAT(email) AS str_email FROM customers"; $result = mysql_query($sql);