[SOLVED] How do you add...?

[paulman888888]

I would like to add another colum.

But my atemps failed.

i would like to add ID

This is my code for name and score

<?php
// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM example ORDER BY score DESC") 
or die('O no. Theres an error');  

echo "<table border='1'>";
echo "<tr> <th>Name</th> <th>Score</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row['name'];
echo "</td><td>"; 
echo $row['score'];
echo "</td></tr>"; 
} echo "</table>";
?>

[Psycho]

Put the html in a more logical format and it will be easier:

 

<?php
// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM example ORDER BY score DESC") 
or die('O no. Theres an error');  

echo "<table border='1'>";
echo "<tr><th>ID</th><th>Name</th><th>Score</th></tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr>\n";
echo "<td>".$row['id']."</td>\n";
echo "<td>".$row['name']."</td>\n";
echo "<td>".$row['score']."</td>\n";
echo "</tr>\n"; 
} echo "</table>";
?>