Welcome to WebmasterWorld Guest from 126.96.36.199 , register , free tools , login , search , pro membership , help , library , announcements , recent posts , open posts Become a Pro Member
how to manage products with different flags? PHPycho
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?
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
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