Hello, can someone tell me how can I output all fields of a row in a mysql db using php? and then write.

Hi,

Here is a small piece of code that will generate a table with field names as headings and then rows for the data: -



<?

$qstr = “Select * from table_name”;

$qry = mysql_query($qstr);

$flds = mysql_fetc_field($qry);



Echo “<table border =1>”;

Echo “<tr>”;

$i = 0;
while ($i < mysql_num_fields($qry)) {

echo “<td>” . mysql_fetch_field($qry, $i) . “</td>”;
$i++;

}



$j = 0;

While ($arr = mysql_fetch_array($qyr)) {

Echo “<tr>”;

While ($j <= $i) {

Echo “<td>” . $arr[$j] . “</td>”;

$j++;

}

Echo “</tr>”;

$j = 0;

}

Echo “</tr>”;

Echo “</table>”

?>

__________________
Maneet Puri
Web Design Company / Data Processing Services

that is very good answer.