Thanks guys that worked perfectly.
Im now having trouble with my table output. The table prints the 1st record from my table and then the second one right next to it. For example:
forename1 projectno1 projecttitle1 forename2 projectno2 projecttitle2
I want the two records to be on seperate lines like so:
forename1 projectno1 projecttitle1
forename2 projectno2 projecttitle2
Im guessing its something to do with the highlighted line
My code looks like this:
echo "<tr><td>Student Name</td><td>Student No</td><td>Project Title</td><td>Specifications</td><td>Designs</td><td>Demonstrations</td><td>Reports</td></tr>";
while($row = MySQL_fetch_array($result))
{
echo "<td>{$row['forename']} {$row['surname']}</td>";
echo "<td>{$row['studentno']}</td>";
echo "<td>{$row['projecttitle']}</td>";
echo '<td><a href="">Mark/Edit</a> <a href="">View</a></td>';
echo '<td><a href="">Mark/Edit</a> <a href="">View</a></td>';
echo '<td><a href="">Mark/Edit</a> <a href="">View</a></td>';
echo '<td><a href="">Mark/Edit</a> <a href="">View</a></td>';
}
Do I need a <br> at the end ?