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?
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.
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.