Php Code: Mysql result all

There is a PHP function named odbc_result_all which returns the query results in a table. I have frequently found it useful to have the same function for MySQL queries. This function will create a table populated with the data as well as the field names.

Usage:




$result = dbQuery("SELECT * FROM tableName");

mysql_result_all($result);




I am not a PHP master, so any improvement suggestions are welcome.

<!-- This Script is from www.hawkee.com, found at www.phpfreecode.com-->function mysql_result_all($result) { $nrow = 0; echo("<table border=1 cellpadding=5 cellspacing=0><tr><th>Row</th>\n"); for($i = 0; $i < mysql_num_fields($result); $i++) echo("<th>".mysql_field_name($result, $i)."</th>\n"); echo("</tr>\n"); while($row = mysql_fetch_array($result)) { echo("<tr><td>$nrow</td>"); for($i = 0; $i < mysql_num_fields($result); $i++) echo("<td>$row[$i]</td>\n"); echo("</tr>\n"); $nrow++; } echo("</table>\n");}<br><font face="Tahoma"><a target="_blank" href="http://www.phpfreecode.com/"><span style="font-size: 8pt; text-decoration: none">PHP Free Code</span></a></font>