mysql_connect("localhost", "db_user", "db_passwd") or die(mysql_error());
mysql_select_db("db_name") or die(mysql_error());
$result = mysql_query("SELECT * FROM db_table ORDER BY sname ASC");
echo '<table align="center" border="0"><tr><td align="center"><img src="some_img.jpg" width="600" height="105" border="0" alt="#"></td></tr></table>';
if ($result) {
echo '<table align="center" border="1" style="font-family:verdana; font-size: 11px;">';
echo '<tr><td align="center" colspan="10">Entries sorted by Surname</td></tr>';
echo '<tr><td>Date</td><td>First Name</td><td>Surname</td><td>Email</td><td>Tele</td><td>City</td><td>Postcode</td><td>Job Title</td><td>Interested in?</td><td>CV</td></tr>';
while($row = mysql_fetch_assoc($result)){
echo "<tr><td>".$row['date']."</td><td>".$row['fname']."</td><td><a href='edit.php?id=$row[id]'>".$row['sname']."</a></td><td width='225'>".$row['email']."</td><td>".$row['tele']."</td><td>".$row['city']."</td><td>".$row['postcode']."</td><td>".$row['jobtitle']."</td><td>".$row['department']."</td><td><a href=".$row['url'].">CV File</a></td></tr>";
}
echo '</table>';
mysql_close();
} else {
echo 'There was an error!';
}
?>