<html>
<head>
<title> Current Rentals </title>
</head>
<body>
<server>
cursor = database.cursor("select * from customer, rentals, videos where rentals.returnDate IS NULL AND rentals.customerId = customer.ID AND rentals.videoId = videos.id");
</server>
<table border>
<caption> 
Rentals by Customer <br>
click on title to return
</caption>
<tr>
  <th>Title</th>
  <th>Customer</th>
  <th>Due Date</th>
</tr>
<server>
while(cursor.next()) {
</server>
<tr>
  <th><a href=`"return.html?videoID="+cursor.videoId+"&customerID="+cursor.customerId`><server>write(cursor.title);</server></a></th> 
  <td><server>write(cursor.name);</server></td> 
  <td><server>write(cursor.duedate.toLocaleString());</server></td> 
</tr>
<server>
}
cursor.close();
</server>
</table>
<p><A HREF="3">Home</A>
</body>
</html>

