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]