Viewing last inserted data from mysql

<?
include("dbinfo.inc.php");
mysql_connect($server,$username,$password);
@mysql_select_db($database) or die( "Unable to select database"); 

$query = "INSERT INTO contacts VALUES ('','$first','$last','$phone','$mobile','$fax','$e  mail','$web','$case')";
mysql_query($query);

mysql_close();


?>
<?
include("dbinfo.inc.php");
mysql_connect($server,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT * FROM contacts WHERE email='$email' LIMIT 0, 10 ORDER BY ID ASC";
$result=mysql_query($query);

$num=mysql_numrows($result); 

mysql_close();


?>
<?
$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");	
$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web"); 
$case=mysql_result($result,$i,"case"); 
?>
<table border="0" cellspacing="5" cellpadding="3" width="50%">
<tr> 
<td BGCOLOR="#CCCC99"><font face="Arial, Helvetica, sans-serif">SUPPORT CASE ID: </font><font face="Arial, Helvetica, sans-serif"><? echo "$id"; ?></font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$id"; ?> Name</font></td><td><font face="Arial, Helvetica, sans-serif"><? echo "$first $last"; ?></font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif">Phone</font></td><td><font face="Arial, Helvetica, sans-serif"><? echo "$phone"; ?></font></td> 
</tr>
<tr> 
<td><font face="Arial, Helvetica, sans-serif">Mobile</font></td><td><font face="Arial, Helvetica, sans-serif"><? echo "$mobile"; ?></font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif">Fax</font></td><td><font face="Arial, Helvetica, sans-serif"><? echo "$fax"; ?></font></td> 
</tr>

<tr><td><font face="Arial, Helvetica, sans-serif">E-mail</font></td><td><font face="Arial, Helvetica, sans-serif"><a href="mailto:<? echo "$email"; ?>"><? echo "$email"; ?></a></font></td> 
</tr>

<tr><td><font face="Arial, Helvetica, sans-serif">Website</font></td><td><font face="Arial, Helvetica, sans-serif"><a href="<? echo "$web"; ?>"><? echo "$web"; ?></a></font></td> 
</tr>

<tr> <td>&nbsp;
</td><td>&nbsp;
</td>
</tr>
<tr> <td>Din Case:
</td><td>
</td>
</tr>
</table>

<table border="0" BORDERCOLOR=black cellspacing="5" cellpadding="3" width="75%">
<tr><td><font face="Arial, Helvetica, sans-serif"><? echo "$case"; ?></font></td>
<?
++$i;
} 
echo "</table>";


?>