array in array

[Anon]

I need to create an array with arrays as elements... data came from a bd

$arr=(arr("label", data),
arr("label", data);

label and data are retrieved from a postgresql bd...

how can i automate it?

[phigga]

now, i'm not sure if this is the BEST way...but since no one's responded, i'll give you my solution. I'm going to wter it down for the sake of brevity (no error checking and whatnot). If anyone has something better, by all means post it....

---

$arr = array(array());
$counter = 0;

$sql = "SELECT label, data FROM some_table;"
$result =pg_exec($sql);
while ($row = pg_fetch_array($result, $counter)){
$arr[$counter][0] = $row[label];
$arr[$counter][1] = $row[data];
$counter++;
}

---

i know that code similar to this works for MySQL, but not sure about my Postgres syntax (it's been a while).

[amcgrath]

Why not:

$tick = 0;

$sql = "SELECT label, data FROM some_table;"
$result =pg_exec($conn,$sql);
while ($row = @pg_fetch_array($result, $tick)){
$my_arr[] = array("label" => $row["label"],
"data" => $row["data"]);
}