Re: Shopping Cart

Shopping Carts are pretty easy to write. Just make a new table in your mysql DB and then write a session_id together with the sku and name, color, size, quantity and maybe customer_id into the the new shoppingcart table. When you want to show the shopping carts content just do an select from the carts table. As I save the prices into an extra table I do a SELECT * FROM basket, price, item WHERE basket.sku = item.sku AND item.price = price.key Later i use a price.q1 field and multiply it with the quantity of the item to get the full price. Hope this helps you a little. Sascha ----- Original Message ----- From: "Chris Cook" <cjc1800@hotmail.com> To: <php-general@lists.php.net> Sent: Sunday, February 09, 2003 10:35 PM Subject: [PHP] Shopping Cart > Hello everybody, > > I am interested in designing a site with a shopping cart. I have several > years of programming experience in php and perl, but I have never made a > shopping cart. > > I was looking into some of the already made shopping carts and was wondering > what peoples' experiences have been with already made shopping carts. > Ultimately, I am wondering whether I should code it from scratch or not. > > Thanks in advance for any help, > Chris > > > _________________________________________________________________ > STOP MORE SPAM with the new MSN 8 and get 2 months FREE* > http://join.msn.com/?page=features/junkmail > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >