build an array from a mysql query result

[richie]

Hi,

I need to build an array from a mysql resultset. The array will be in the form:

$array = Array ("[e-mail]", "[e-mail]", "[e-mail]")

Here is my approach:

$query = "select email from db";

$result = mysql_db_query($db,$query,$connection);

$array = "array ("; // OPEN ARRAY

while($myrow = mysql_fetch_array($result)){
$email = $myrow["email"];

$array .= "\"".$email."\", ";

}

Once the loop is complete, I should have something like this:

$array = array ("[e-mail]", "[e-mail]", "[e-mail]",

// I do not need the last "comma and space" at the end

$array = substr($array, -2);

$array .= ")"; // CLOSE ARRAY

To produce:

$array = Array ("[e-mail]", "[e-mail]", "[e-mail]")

---

Unfortunately, when I do the following and then ECHO $array, I get something similar to this:

, ", ")

---

But when I echo $email, the values are printed.

I just need an idea about how to build my array from the mysql result.

Thx.

Richie.

[jernhenrik]

Are you trying to build a string to look like an array or are you trying to fill a normal array. I don't quite understand your post.
If you are trying to fill up an array you could do something like this..

$arr=array();
$counter=0;
query = "select email from db";
$result = mysql_db_query($db,$query,$connection);

while($myrow = mysql_fetch_array($result))
{
$arr[$counter]=$myrow["email"];
$counter++;
}

hth

[richie]

I was actually trying to fill an array, but couldn't quite find the right words.

Thanks. Your response answered my question.

[Mordecai]

Rather than using $counter as in the above script, just use an emtpy bracket:
$array[]