php mySQL - added "formatted output" with "error trapping" and "include" to the previous code

Include File:

<?php
$user="root";
$password="passpass";
$database="myfirstdatabase";
?>


Script File:

<?php

include("dbinfo.inc.php");

$link = mysql_connect('localhost',$user,$password);
if (!$link){
  die('Could not connect: ' . mysql_error());
}
echo "connected to server<br />";
if (!mysql_select_db($database)){
    die('Could not select database: ' . mysql_error());
}
echo "connected to database<br />";
$query="SELECT * FROM contacts";
$result=mysql_query($query);
$num=mysql_numrows($result);

if($num==0){
  echo "The database contains no contacts yet";
}
else{
  echo "<b><center>Database Output</center></b><br><br>";
  ?>
 
  <table border="0" cellspacing="2" cellpadding="2">
  <tr>
  <th><font face="Arial, Helvetica, sans-serif">Name</font></th>
  <th><font face="Arial, Helvetica, sans-serif">Phone</font></th>
  <th><font face="Arial, Helvetica, sans-serif">Mobile</font></th>
  <th><font face="Arial, Helvetica, sans-serif">Fax</font></th>
  <th><font face="Arial, Helvetica, sans-serif">E-mail</font></th>
  <th><font face="Arial, Helvetica, sans-serif">Website</font></th>
  </tr>
 
  <?php
  $i=0;
  while ($i < $num){
    $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");
  ?>
 
  <tr>
  <td><font face="Arial, Helvetica, sans-serif"><?php echo $first." ".$last; ?></font></td>
  <td><font face="Arial, Helvetica, sans-serif"><?php echo $phone; ?></font></td>
  <td><font face="Arial, Helvetica, sans-serif"><?php echo $mobile; ?></font></td>
  <td><font face="Arial, Helvetica, sans-serif"><?php echo $fax; ?></font></td>
  <td><font face="Arial, Helvetica, sans-serif"><a href="mailto:<?php echo $email; ?>">E-mail</a></font></td>
  <td><font face="Arial, Helvetica, sans-serif"><a href="<?php echo $web; ?>">Website</a></font></td>
  </tr>
 
  <?php
  $i++;
  }
 
  echo "</table>";
}
mysql_close($link);
echo "disconnected <br />";
?>