Each time a user click's "Add to Cart" a record is added to your Cart table. This table will have several key fields, one being unique to that row, one which relates back to the customer (a Customer ID) and one which relates back to the product (a Product ID). Another colum would indicate the staus of this items in the cart. Example 1=added but not purchased; 2=Added then deleted; 3=Added and purchased. When that visitor comes back, your SQL statement which populates his cart will select all items from Cart where Customer ID = current and Status ID = 1. Other data in this table will record the date and time it was added or deleted or purchased, etc. HTH, Casey -----Original Message----- From: Chris Blessing [mailto:webguy at mail.rit.edu] Sent: Friday, April 05, 2002 9:10 AM To: thelist at lists.evolt.org Subject: RE: [thelist] Backend of a shopping cart system... But then how would I maintain their cart after the session expired? Chris Blessing webguy at mail.rit.edu http://www.330i.net > You have a session table and write the contents of their sesion to > that. When they log out that deletes the row in the table associated > with their sessionID > > Julian -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt !