How to create a table in PHP with MySQL?

HOw do I get PHP/MySQL output in a table to be numbered?

• have a MySQL DB that has a DB w/ one table, that having two rows. I use this PHP to retrieve it and put it into a table (It's for hi-scores): $fetch = mysql_query("SELECT * FROM scores ORDER BY score DESC LIMIT 10"); while($row = mysql_fetch_array($fetch)) { echo "<table border='1' width=300><tr><td>&nbsp $row[name] &nbsp</td><td>&nbsp $row[score] &nbsp</td></tr></table>"; } I would like to have each horizontal row have a number before it, numbered 1 - 10 (it's a hi-score platform). How would I do that? Keep in mind that I don't want them numbered as they are in the DB, but as they are sorted and listed on the page. Help? The page is here: http://pennyontherail.com/score10.php . Thank you very much!

• Answer:

  First thing, it's not a good idea to do SELECT *, just select the fields that you want, even if * is all of them. Why? Because it causes strain on the db engine. Another thing, you do not need to create a table for each iteration. Just one table, then loop through the rows. To make your numbers, you will want to add a number to the loop, eg: <table> <thead> <tr> <th>Number</th><th>Person</th><th>Scor… </tr> </thead> <tbody> <?php while($row = mysql_fetch_array($fetch)) { $i = $i+1 $name = $row[0]; $score = $row[1]; ?> <tr> <td><?php echo $i; ?></td><td><?php echo $name; ?></td><td><?php echo $score; ?></td> </tr> <?php } mysql_free_result($fetch); ?> </tbody> </table>