Posted By

ginoplusio on 01/25/10

Tagged

mysql
php
html

Versions (?)

Last Edited at 01/25/10 10:57am

Statistics

Viewed 1120 times

Favorited by 1 user(s)

Related snippets

MYSQL Recordset to HTML table

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

function getHtmlTable($result){
	// receive a record set and print
	// it into an html table
	$out = '<table>';
	for($i = 0; $i < mysql_num_fields($result); $i++){
		$aux = mysql_field_name($result, $i);
		$out .= "<th>".$aux."</th>";
	}
	while ($linea = mysql_fetch_array($result, MYSQL_ASSOC)) {
		$out .= "<tr>";
		foreach ($linea as $valor_col) $out .= '<td>'.$valor_col.'</td>';
		$out .= "</tr>";
	}
	$out .= "</table>";
	return $out;
}