Posted By

cubit on 12/14/07

Tagged

php
html

Versions (?)

Last Edited at 12/14/07 12:43pm

Statistics

Viewed 843 times

Favorited by 2 user(s)

Related snippets

MySQL Query to HTML Table

/ Published in: PHP

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

function _mysql_result_all($result, $tableFeatures="border='1'",$nodata="&nbsp;") {
$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);