[Resolved] mysql query results as array of row arrays?

[chucklarge]

Hi,
I am trying to figure out how to get the mysql query results as an array of arrays. So right now, i have this

$result2 = mysql_query("SELECT blah blah blah") or die (mysql_error());                      

while ($row2 = mysql_fetch_assoc ($result2))
{ // stuff here }

Ok, so in my case, for each iteration of the while statement is of this form, $row2 =

Array ( [id] => 1 [date] => 2005-02-10 [description] => aaaa )

I am trying to figure out how i can get all the results together in an array like this

Array ( Array ( [id] => 1 [date] => 2005-02-10 [description] => aaaa ) 
Array ( [id] => 2 [date] => 2005-02-10 [description] => bbbb ) 
Array ( [id] => 3 [date] => 2005-02-10 [description] => test123 ) )

Any Ideas?

[neque]

won't this work

$i=0;
$result2 = mysql_query("SELECT blah blah blah") or die(mysql_error());

while ($row2 = mysql_fetch_assoc ($result2))
{
$arr[$i]=$row2;
$i++;
}

[chucklarge]

Yep, that works exactly as I needed. Thanks