array not being populated

[kev wood]

i am trying to create an array of email address stored in a mysql db and store the result into a php variable to be used in the BCC section of an email.  up to now the code i am using is only placing one email address into the php variable.

 

here is the code

 

	$query = "SELECT email FROM emails";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)) {

$contactemail = $row['email'];
}

 

arrays are not my strong point as you can prob tell from the code i have written.

[Mchl]

You're assigning a value to a variable. Use code below to fill in array.

 

$contactemail[] = $row['email'];

[jackpf]

Lol Mchl beat me to it.

 

Just wondering, why do you need it in an array anyway? Can't you just perform the action you wish to perform in the while() loop?