Listing results in HTML table!

[ericg212]

I know this has a simple solution, but right now I can't find it!

$currentSports = "SELECT * FROM Sports ORDER BY sport";
$result = mysql_query( $currentSports, $link);
while ($currentSports = mysql_fetch_array($result))
{
$id = $currentSports['id'];
$sport = $currentSports['sport'];
$description = $currentSports['description'];
echo "<table border=1>\n
<td><b>Sport</b></td><td><b>Description</b></td>\n<td><b>&nbsp</b></td>\n
<tr><td><a href=\"updatesport.php?sport_id=$id[id]&".SID."\">".$sport."</a></td>\n
<td>$description</td>\n
<td>delete<br></td>\n
</tr>\n
</table>\n";
}
?>

I want to list the results in one table, but the code makes a new table for each result set. What do I need to change.

[ahundiak]

Move the <table> and column name code outside of the while loop.

[ericg212]

Duh!

Thanks, that did it.

[adrian_quah]

here's a piece of code that'll have alternate colours in ur table display:

<table>
<?php
// For alternate row colour
$row_colour="#FFFFCC";
$count_rows = 0;

//loop and display the limited records being browsed
while ($arr = mysql_fetch_array($rs))
{
$count_rows++;
if ($count_rows%2==0)
{ $row_colour="#FFFFCC"; } // Even-numbered rows
else
{ $row_colour="#CCCC99"; } // Odd-numbered rows
?>
<tr bgcolor="<?php echo $row_colour; ?>">
<td>____</td>
</tr>
<?php }; ?>
</table>

hope u find this helpful!