Building specyfied Array from SQL query

[mlewczuk]

Hello,
I have problem with array: I don't know how to build this array dynamically from database (mySql) :

$description = "test";
$recipients = array($description,'somethink')

this last element "somethink" shoud be taken from database and repeated x-times (I mean that each record from DB shoud change "somethink")... so after this Array shoud looks like this:

$description = "test";
$recipients = array($test,'somethink1','somethink2','somethink3','somethink4','somethink5','somethink6','somethink7',...,'somethink1291')

I'm looking forward for your answers.😃 😃 🆒

[mlewczuk]

Thanks to user jowatkins I know how to do it, so you dont have to think about it anymore:

$result = mysql_query("SELECT somefield FROM sometable ");
$num_results = mysql_num_rows($result);
$somethink = array();
$somethink[] = "description of an array";

//use the for loop to populate the array with the emails from the query

for ($i; $i<$num_results; $i++)
{
$row=mysql_fetch_object($result);
$somethink[]=$row->somefield;
}

So after this this Array will looks like this:

$somethink = array('description of an array','somefield_result1',,'somefield_result2','somefield_result3',...)

Thanks.

[bastien]

<?
$sql = "select * from usertable";

$result=mysql_query($sql, $conn) or die ("database not available");

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

   $recipient = $row["recipient"];

   $recipient_array = $recipient_array.",".$recipient

}

/*

this creates an array of recipients separated by commas. you can then do whatever you need with this

*/
?>

hth

[the_Igel]

write a loop like

while ($row = mysql_fetch_array($result))
{
$recipients[] = $row[0];
}

are there any problems?