Loading a mysql_fetch_row into an array

[Anon]

I'm pulling my hair with this one, and I can't find an obvious solution.

Basically, I want to load all the rows retrieved during a while(mysql_fetch_row) loop into an array which can then be accessed globally outside of the loop. Is it possible, or are the limitations of initiating an array preventing it?

what I want to do is something like...

while ($query=mysql_fetch_row($dbquery) {
$query_array=xxxx // load the rows into an array
}
$foo=$query_array[0][1]; //2nd field from first row?
$bar=$query_array[1][4]; //4th field from 2nd row?

I think this will require a multidimensional array, but since I can't see how to load such an array, I'm a bit stumped

[nigel_belanger]

Try this

while ($result = mysql_fetch_row ($result))
{
echo "$result[0] $result[1] $result [3]";
}

This will return the 1st, 2nd and 3rd column in a row. It will show the first row and continue until there are not rows left to display.

Hope this helps!

[Anon]

yes, and so I have the $result[0], $result[1]... etc for the 1st, 2nd... rows, but I need to then stick all that data into an array which is required outside of the while{} loop.

arrays puzzle me at the best of time, but I guess
$result_array=array("$result[0]","$result[1]","...");

will load the row into the array $result_array, but how do I then load the next row into the same array, but on the second dimension?

[nigel_belanger]

Ok...

You could use something like:

$therow=mysql_result($result[1], $row[])

$result[x] is the column name from the while clause and $row[x] could be from a nested while clause. Then just echo out the value of $therow

That is my thinking...take a look here:

http://www.php.net/manual/en/function.mysql-result.php

Let me know what you come up with...

[Anon]

Here are 2 examples:

$data = array();
$row_nr = 0; // rows begin from 0
while ($result = mysql_fetch_row($dbquery))
{
$data[$row_nr][0] = $result[0];
$data[$row_nr][1] = $result[1];
$data[$row_nr][2] = $result[2];
$data[$row_nr][3] = $result[3];
$row_nr++;
}

... or with mysql_fetch_array:

$data = array();
$key = 0;
while ($result = mysql_fetch_array($dbquery))
{
$data[$row_nr][field_1] = $result[field_1];
$data[$row_nr][field_2] = $result[field_2];
$data[$row_nr][field_3] = $result[field_3];
$data[$row_nr][field_4] = $result[field_4];
$row_nr++;
}

[Anon]

$data=array()
while($result=mysql_fetch_assoc($dbquery))
{ $data[]=$result;
}

echo'<pre>';
print_r($data);
echo'</pre>';

[Anon]

<?
while ($row = mysql_fetch_assoc ($result)) {
$result_array[] = $row;
}
?>

$result_array is now a 2D array with numeric keys and values which are associative arrays of field names and field values. You can now refer to this array outside the loop, for example, to access the value of "last_name" in row number 32 you would write:
echo $result_array['31']['last_name'];

[Anon]

You guys are great -
thanks to you all. Things are much clearer now.
cheers