note 62270 added to function.mysql-fetch-assoc

What if you *want* a two dimensional array? Useful for output as an HTML table, for instance. function mysql_resultTo2DAssocArray ( $result) { $i=0; $ret = array(); while ($row = mysql_fetch_assoc($result)) { foreach ($row as $key => $value) { $ret[$i][$key] = $value; } $i++; } return ($ret); } print_r(mysql_resultTo2DAssocArray(mysql_query("SELECT * FROM something"))); Array ( [0] => Array ( [symbol] => ARNA [datetime] => 2006-02-17 16:00:00 [price] => 16.83 ) [1] => Array ( [symbol] => CALP [datetime] => 2006-02-17 16:00:00 [price] => 6.54 ) [2] => Array ( [symbol] => CROX [datetime] => 2006-02-17 16:00:00 [price] => 27.4 )) ---- Server IP: 216.194.113.175 Probable Submitter: 207.237.238.22 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-fetch-assoc.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+62270 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+62270&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+62270&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+62270&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+62270&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+62270&report=yes&reason=non-english Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+62270&report=yes&reason=already+in+docs Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+62270&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+62270&report=yes Search -- http://master.php.net/manage/user-notes.php