function _mysql_result_all($result, $tableFeatures="border='1'",$nodata=" ") {
$tableDebug .= "<!--Debugging output for SQL query-->\n\n";
echo "<table $tableFeatures>\n\n";
$noFields = mysql_num_fields($result);
echo "<tr>\n";
for ($i = 0; $i < $noFields; $i++) {
$field = mysql_field_name($result, $i);
echo "\t<th>$field</th>\n";
}
while ($r = mysql_fetch_row($result)) {
echo "<tr>\n";
foreach ($r as $column) {
echo "\t<td>";
if ($column == NULL) {
			echo "$nodata";
		} else {
			echo $column;
		}
echo "</td>\n";
}
echo "</tr>\n";
}
echo "</table>\n\n";
echo "<!--End debug from SQL query-->\n\n";
return $tableDebug;
}


_mysql_result_all($result);

function _mysql_result_all($result, $tableFeatures="border='1'",$nodata=" ") {
$tableDebug .= "<!--Debugging output for SQL query-->\n\n";
echo "<table $tableFeatures>\n\n";
$noFields = mysql_num_fields($result);
echo "<tr>\n";
for ($i = 0; $i < $noFields; $i++) {
$field = mysql_field_name($result, $i);
echo "\t<th>$field</th>\n";
}
while ($r = mysql_fetch_row($result)) {
echo "<tr>\n";
foreach ($r as $column) {
echo "\t<td>$column";
if ($column == NULL) {
			echo "$nodata";
		} else {
			echo $column;
		}
echo "</td>\n";
}
echo "</tr>\n";
}
echo "</table>\n\n";
echo "<!--End debug from SQL query-->\n\n";
return $tableDebug;
}



_mysql_result_all($result);

function _mysql_result_all($result, $tableFeatures="") {
$table .= "<!--Debugging output for SQL query-->\n\n";
$table .= "<table $tableFeatures>\n\n";
$noFields = mysql_num_fields($result);
$table .= "<tr>\n";
for ($i = 0; $i < $noFields; $i++) {
$field = mysql_field_name($result, $i);
$table .= "\t<th>$field</th>\n";
}
while ($r = mysql_fetch_row($result)) {
$table .= "<tr>\n";
foreach ($r as $column) {
$table .= "\t<td>$column</td>\n";
}
$table .= "</tr>\n";
}
$table .= "</table>\n\n";
$table .= "<!--End debug from SQL query-->\n\n";
return $table;
}



print _mysql_result_all($result);

http://www.thescripts.com/forum/thread276.html

Not mine. Changed from the original it to suit my needs.

MySQL Query to HTML Table

php, html

PHP