At 03:17 PM 4/10/2001 -0400, Matt Braynard wrote:
>I'm trying to build a shopping cart and am unsure of how to track what each
>visitor has purchased as they shop. How do I track what items they add as
>they move through the online catalog adding things and then checkout.

Make a table that represents items purchased.  In this table include at 
least, the product ID, customer ID and a status column which represents "in 
basket", "purchased", "shipped", "frozen", etc.  Once an order has been 
completed just update the status to "purchased".

Cheers

-----------------------------------------------------------------------------
Island Net AMT Solutions Group Inc.          Telephone:          250 383-0096
1412 Quadra                                  Toll Free:        1 800 331-3055
Victoria, B.C.                               Fax:                250 383-6698
V8W 2L1                                      E-Mail:    [EMAIL PROTECTED]
Canada                                       WWW:   http://www.islandnet.com/
-----------------------------------------------------------------------------


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to