Creating HTML Tables with PHP

[Anon]

Greetings...

I need to output data from a database into tables. How can I do this for any amount of tables? Say I have 10 records in the DB, how do I write my code so it produces a table with a separate table cell for each record? But the next day I might have 20 records? How do I make sure the PHP code can keep on adding table cells without me having to code in each table.

Thanks

[maxpup979]

If I understand you correctly, you need to loop across the recordset. You can do something along the lines of:

for($i=0;$i<count($result);$i++){
print "<tr>";
print "<td>".pg_result($result,$i,"fieldname")."</td>";
print "<td>".pg_result($result,$i,"fieldname2")."</td>";
print "</tr>"
}

Hope this helps
Darren

[Anon]

print "<table>";
for ($i = 1; $i <= count($data_rows_returned); $i++) {
print "<tr><td>".$data_returned_row_$i."</td></tr>";
}
print "</table>";

Ofcourse this is simplified code, you'll need to tailor it to your setup. But if you just start a loop and grab each successive row from your table, then generate a table row to hold that data it will always expand to fit all of the data.

[Anon]

// Display the table of each row
while ( $row = mysql_fetch_array($result) ) {
$bgcolor = ($i++ & 1) ? '#ffffff' : '#cccccc';
print("<tr bgcolor='$bgcolor'><td><b>");
printf("%s</td>\n",
$row["name"]);
printf("<td>%s</td>\n",
$row["ip"]);
printf("<td>%s</td>\n",
$row["term"]);
printf("<td>%s</b></td></tr>\n",
$row["make"]);
}