[thelist] Shopping Carts -- where to store price

Anthony Baratta Anthony at Baratta.com
Sat Sep 9 18:51:45 CDT 2000

"Warden, Matt" wrote:
> 'volters,
> In recent projects where I'm building a shopping cart system from scratch,
> I've always decided to store the product foreign key as well as the product
> price in the cart table. Even though price is also in the product table. I

This is what I do also. Saves on a database call. Unlike Amazon, I don't like to see
prices change on customers. ;-)

Anthony Baratta
KeyBoard Jockeys
                    South Park Speaks Version 3 is here!!!
                              Powered by Tsunami

More information about the thelist mailing list