How do I get PHP table to format and auto number?

  • Thread starter Thread starter falcon_developer
  • Start date Start date
F

falcon_developer

Guest
I 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>";

}

Originally, the middle space between two horizontal cells were the same, but the outside edges were shrunk to the text. Ia used the "width" command in my table tag, but now the center line is screwed up. (The page is here: http://www.pennyontherail.com/score10.php)
How do I fix that? Also, I would like to have the scores numbered, from 1 to 10. IS that done in PHP, or in the DB. Keep in mind that the scores are in a different order in the DB, and that I am sorting them with the query.


Help?
srry, linky typ. it should be

http://www.pennyontherail.com/score10.php
 
Back
Top