Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

how to manage products with different flags?

8:03 am on Feb 23, 2010 (gmt 0)

Junior Member

10+ Year Member

joined:Jan 6, 2006
votes: 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?
4:21 pm on Feb 23, 2010 (gmt 0)

Moderator from US 

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Dec 10, 2005
votes: 88

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)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Dec 15, 2003
votes: 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.

prod_id, prod_name, flag_id

flag_id, flag_name, flag_desc