note 62394 deleted from function.mysql-fetch-field by bjori

Note Submitter: jordan dot ledoux at gmail dot com ---- Here's a function which compiles an array out of a mysql query for any number of columns using this function: <? function compile_array($mysql) { $i = 0; while ($field = mysql_fetch_field($mysql)) { /* Create an array $fields which contains all of the column names */ $fields[$i] = $field->name; $i++; } $i = 0; while ($mysql_result = mysql_fetch_array($mysql)) { foreach ($fields as $val) { /* Compiles an array in the format: $data [ row number ] [ column name ] */ $data[$i][$val] = $mysql_result[$val]; } $i++; } return $data; } ?>