* @version 1.0.3 * @link http://aidanlister.com/repos/v/function.mysql_draw_table.php * @param array $result The result of a mysql_query * @param string $null Text to replace empty values with */ function mysql_draw_table($result, $null = ' ') { // Sanity check if (!is_resource($result) || substr(get_resource_type($result), 0, 5) !== 'mysql') { return false; } $out = "\n"; // Table header $out .= "\t"; for ($i = 0, $ii = mysql_num_fields($result); $i < $ii; $i++) { $out .= ''; } $out .= "\n"; // Table content for ($i = 0, $ii = mysql_num_rows($result); $i < $ii; $i++) { $out .= "\t"; $row = mysql_fetch_row($result); foreach ($row as $value) { // Display empty cells $value = (empty($value) && ($value != '0')) ? $null : htmlspecialchars($value); $out .= ''; } $out .= "\n"; } $out .= "

' . mysql_field_name($result, $i) . '
' . $value . '

\n"; echo $out; } ?>