I have a query select all rounds where username = ‘$user’
this is my code
$result = mysql_query("SELECT * FROM rounds WHERE username = '$user'");
echo "<table width='600' border='1'>
<tr>
<th>Course</th>
<th>Date Played</th>
<th>Par</th>
<th>Strokes</th>
<th>+/-</th>
</tr>";
while ($row=mysql_fetch_array($result)) {
echo "<tr>
<td align='center'>",$row['courseplayed'],"</td>
<td align='center'>",$row['dateplayed'],"</td>
<td align='center'>",$row['par'],"</td>
<td align='center'>",$row['score'],"</td>
<td align='center'></td>
</tr>
</table>";
;}
?>
it pulls all the data correctly but only puts one of the results in the table the rest are under the table. What am I missing to get all the results in the table?