[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