I'm working on a long response.... Stay tuned! -----Original Message----- From: Chris Blessing [mailto:webguy at mail.rit.edu] Sent: Friday, April 05, 2002 9:26 AM To: thelist at lists.evolt.org Subject: RE: [thelist] Backend of a shopping cart system... But again, once the user ends their session, I have no idea what their customer id was nor do I know what it will be the next time they start a session... right? Unless I write out that specific id to a cookie... I can't bind it to their already-unique user account because I don't want to require them to login/create an account before populating their cart. Chris Blessing webguy at mail.rit.edu http://www.330i.net > 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 -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt !