[PHP-DB] Building a Shopping Cart

2001-04-10 Thread Matt Braynard

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. 



-- 
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]


Re: [PHP-DB] Building a Shopping Cart

2001-04-10 Thread Ron Brogden

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]