// Select all customers so we may create a list to choose from below. cursor = database.cursor("select * from customer order by ID");

## Customers by ID

Click on ID to remove the customer
ID | Name | Address | City | State | ZIP | Telephone
--- | --- | --- | --- | --- | --- | ---
/* Dynamically create a table filled with all of the customers in the CUSTOMER table as specified by the database query at the top of the page. We also make each customer ID a link to the "remove.htm" page, with the ID value an argument of the URL string so that it will be passed to "remove.htm" as a property of the REQUEST object. */ while(cursor.next()) {
write(cursor.ID); | write(cursor.name); | write(cursor.address); | write(cursor.city); | write(cursor.state); | write(cursor.zip); | write(cursor.phone);
}