I can't seem to nail down the simplest way to do this. I've got
10-15 lines of code right now to do something that should take less. The
following code extracts the names of all the fields in a table, prints
them across a table row in their own cells, and then extracts each
record and prints a table row for each.

$result = mysql_query("SELECT * FROM meatmap");

echo "<table>\r\n";
echo "<tr>\r\n";

$row = mysql_fetch_assoc($result);
foreach($row as $key => $value) {echo "<td>$key</td>\r\n"; }

echo "</tr>\r\n";

mysql_data_seek($result, 0);

while($row = mysql_fetch_assoc($result)) {
 echo "<tr>";
 foreach($row as $key => $value) {echo "<td>$value</td>\r\n"; }
 echo "</tr>";

echo "</table>\r\n";

    I know there has to be an easier way, both concept and code wise, to
do this. Any ideas out there? A message earlier this week gave me the
general idea... the previous way I had been doing this was EVEN MORE


Dan Barton
Terrestrial Program Biologist
Asst. Data Manager
Point Reyes Bird Observatory

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to