mysql query

[Anon]

Hey

How can I print out my entire mysql table.

I have 7 tables, and I want to print out a selected one.

eg.

list_tables.php?tb=TABLENAME

mysql_connect($host,$un,$pw);
mysql_select_db($db);

$query = mysql_query("SELECT * FROM $tb");
$rownum = mysql_num_rows($query);
$i = 0;

while($i < $rownum) {
// THIS IS WHERE I AM HAVING THE PROBLEM, HOW DO I PRINT OUT AN ENTIRE ROW?
$rowinfo = mysql_result($query, $i);
// IF I DO IT LIKE THIS IT ONLY PRINTS THE FIRST FIELD, BUT I HAVE 9 FIELDS IN MY TABLE

  $i++;

}

mysql_close();

[Anon]

Try this :

<?php
$HTTP_GET_VARS['tb'];
$db = mysql_connect("localhost", "outdoor");
mysql_select_db("Outdoors",$db);
$result = mysql_query("SELECT first, second, third FROM $tb",$db);
echo "<table border=1 width=600>";
echo "<tr><td>";
echo "<ul>";
if ($myrow = mysql_fetch_array($result)) {
do {
printf("This is the first %s, this is the second %s, this is the third %s\n", $myrow["first"], $myrow["second"], $myrow["third"]);
} while ($myrow = mysql_fetch_array($result));
echo "</ul>";
echo "</td></tr>";
echo "</table>";
} else {
echo "Sorry, no records were found!";
}
?>

This will put it into a table. I only showed retrieving the first three columns...you can extend it to cover as many as your wish. You can also format the output however you want using the printf function.

Let me know if you have further questions.

Mark