| how to manage products with different flags?
|
PHPycho
msg:4085391 | 8:03 am on Feb 23, 2010 (gmt 0) |
How do you handle product with different flags like featured, new, christmas special, valentine special..?
do you use fields in the same product table (sayroducts)
or different table
But How?
|
LifeinAsia
msg:4085650 | 4:21 pm on Feb 23, 2010 (gmt 0) |
I use both. If it's something I planned for from the beginning (like featured), I'll have a field in the main table. If it's something I decided to add later (like Christmas Specials), and the main table is pretty big, I'll probably make a separate table.
|
Demaestro
msg:4087235 | 6:22 pm on Feb 25, 2010 (gmt 0) |
If there will only be 1 flag active at anytime then I would have flag details stored in a seperate table and then store the flag_id in a column on the main table.
Products:
prod_id, prod_name, flag_id
Flags:
flag_id, flag_name, flag_desc
|
|
|
