<html>
<head>
<title> Customer Database </title>
</head>
<body>
<server>
cursor = database.cursor("select * from customer order by ID");
</server>
<table border>
<caption> Customers by ID <br>
click on ID to remove
</caption>
<tr>
  <th>ID</th>
  <th>Name</th>
  <th>Address</th>
  <th>City</th>
  <th>State</th>
  <th>ZIP</th>
  <th>Telephone</th>
</tr>
<server>
while(cursor.next()) {
</server>
<tr>
  <th><a href=`"remove.html?ID="+cursor.ID`><server>write(cursor.ID);</server></a></th> 
  <td><server>write(cursor.name);</server></td> 
  <td><server>write(cursor.address);</server></td>
  <td><server>write(cursor.city);</server></td>
  <td><server>write(cursor.state);</server></td>
  <td><server>write(cursor.zip);</server></td>
  <td><server>write(cursor.phone);</server></td>
</tr>
<server>
}
</server>
</table>
<p><A HREF="3">Home</A>
</body>
</html>

