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?
how to manage products with different flags??
Moderator: General Moderators
Re: how to manage products with different flags??
You can use the "Entity Attribute Value" database model. Essentially you would create a separate table which stores the product id, attribute name and the attribute value.
http://en.wikipedia.org/wiki/Entity-att ... alue_model
http://en.wikipedia.org/wiki/Entity-att ... alue_model
Re: how to manage products with different flags??
Dude, I don't mean to be rude, but I don't think I've ever seen a question that makes less sense than this. I think I can speak for the entire PHP developer's network when I say...
WHAT??

WHAT??
Re: how to manage products with different flags??
@Luke: Can you elaborate??
Why my question doesn't make much sense???
Why my question doesn't make much sense???
Re: how to manage products with different flags??
I am not a fan of EAV, so I'd suggest using either a bitmask field into the table itself, or using two additional tables - flag and product_has_many_flags table.
There are 10 types of people in this world, those who understand binary and those who don't