[UPHPU] Database Question

Timothy Humphrey timothy.humphrey at gmail.com
Mon Aug 14 13:47:49 MDT 2006


Webot Graphics wrote:
should I continue to have a separate line item for each, or have 1
> table with the sizes in it, 1 table with the products in it, and 1 table 
> that connects the two?

My $.02:
One table: unique_id, product_name, category, size, qty, price, etc....

It stays simple that way. So you have to enter Vanilla Extract 5 times, 
but that happens once. From then on, you have a lightweight, 
straightforward, yet powerful system for your users (and the server too 
I guess).

Timothy


More information about the UPHPU mailing list