rendered paste body<?phpinclude 'library/config.php';include 'library/opendb.php';// if no id is specified, list contacts if(!isset($_GET['id'])) { $self = $_SERVER['PHP_SELF']; $query = "SELECT id, lname FROM contacts ORDER BY lname ASC"; $result = mysql_query($query) or die('Error : ' . mysql_error()); // create the contact list $contact_list = '<ol>'; while($row = mysql_fetch_array($result, MYSQL_NUM)) { list($id, $lname,) = $row; $contact_list .= "<li><a href=\"$self?id=$id\">$lname</a></li>\r\n"; } $contact .= '</ol>'; $page_title = 'Address Book';// get the contact info from database } else { $query = "SELECT lname, fname FROM contacts WHERE id=".$_GET['id']; $result = mysql_query($query) or die('Error : ' . mysql_error()); $row = mysql_fetch_array($result, MYSQL_ASSOC); $lname = $row['lname']; $fname = $row['fname']; } include 'library/closedb.php';?><html><head><title><?php echo $page_title;?></title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"><!--h1 { font-family: Arial, Helvetica, sans-serif; font-size: 18px; color: #006699; font-weight: bold;}.main { padding: 10px; border: 1px solid #006699; position: relative; width: 580px; margin-top: 20px; margin-bottom: 20px; font-family: Arial, Helvetica, sans-serif; font-size: 12px;}--></style></head><body><table width="600" border="0" align="center" cellpadding="10" cellspacing="1" bgcolor="#336699"> <tr> <td bgcolor="#FFFFFF"><h1 align="center"><?php echo $page_title;?></h1><?php echo $contact_list;// when displaying an contact show a link to see the contact list if(isset($_GET['id'])) { ?> <p> </p> <p align="center"><a href="<?php echo $_SERVER['PHP_SELF']; ?>">Back</a></p><?php}?> </td> </tr> <tr> <td bgcolor="#FFFFFF"><a href="admin.php">Admin</a></td></tr></table></body></html>