Hello,

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

<?php

// Select WSR Database
mysql_select_db("wsrskitites");

// 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>
</tr>";

// 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>";

?>