Return mySQL results table as a 2D array

[MattRevell]

Hi,

This is probably a newbie style question but I've spent a lot of time looking for an answer to it, so please forgive me for asking if it's already been solved in these pages.

I've been trying to find a way of returning the full results table from mySQL. mysql_fetch_array() returns it one row at a time, so is there an existing function that returns the entire results table from a query as a two dimensional array?

I tried writing something myself that would create such an array but I'm having trouble with a bizarre array related error at the moment:

Fatal error: Call to undefined function: array()

Don't understand why that's happening as array() is part of the standard PHP function list, isn't it?

Anyway, thanks in advance for any help! If you need any extra info from me, please ask!

[ahundiak]

$rows = array();
while($row = mysql_fetch_assoc($result)) {
$rows[] = $row;
}

[MattRevell]

Great, thanks for the help!