I have the following code listed below, but it is only displaying one entry. Hoping you can help!


// Select WSR Database

// Retrieve all the data from the skisites table
$result = mysql_query("SELECT * FROM skisites")
or die(mysql_error());

echo "<table border='1' width='650' cellpadding='0' cellspacing='0'>

<tr bgcolor='#333333'>
<th valign='top'><p align='center' class='title'><b>State</b></p></th>
<th valign='top'><p align='center' class='title'><b>City</b></p></th>
<th valign='top'><p align='center' class='title'><b>Ski Site</b></th>
<th valign='top'><p align='center' class='title'><b>Website Address</b></p></th>
<th valign='top'><p align='center' class='title'><b>Contact Info</b></p></th>

// store the record of the skisites table into $row
$row = mysql_fetch_array( $result );
// Print out the contents of the entry

echo "<tr>";
echo "<td>".$row['State'] ."</td>";
echo "<td>".$row['City'] ."</td>";
echo "<td>".$row['Site_Name'] ."</td>";
echo "<td>".$row['Website'] ."</td>";
echo "<td>".$row['Contact'] ."</td>";
echo "</tr>";

echo "<br>";

echo "</table>";