Welcome to WebmasterWorld Guest from 184.108.40.206 , register , login , search , subscribe , help , library , PubCon , announcements , recent posts , open posts Subscribe to WebmasterWorld
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