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)

5+ Year Member

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)

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

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)

WebmasterWorld Senior Member demaestro is a WebmasterWorld Top Contributor of All Time 10+ Year Member

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

Featured Threads

Hot Threads This Week

Hot Threads This Month