TalkPHP - View Single Post

ReSpawN · 01-28-2008, 04:43 PM

As an addition to Bill's post, I can advice you to create a property table as well. It's a sort of category table but then using only the number and the name for display.

You'll have a design like this:

Code:

-- Item ID database
item_id     item_property_id
int(15)     int(15)

-- Property Database
property_id    property_name     property_value
int(15)        varchar(255)      varchar(255)

Linking both databases, you would only retrieve the info you wanted, when you want to. Not the complete database with all your information. It's the way that suits me best at the moment, but it might be a little bit exaggerated.

I think Salathe - the guru - will be better at this than me but who cares.

My point of view.

01-28-2008, 04:43 PM	#4 (permalink)
ReSpawN The Frequenter Join Date: Nov 2007 Location: Netherlands Posts: 460 Thanks: 49	As an addition to Bill's post, I can advice you to create a property table as well. It's a sort of category table but then using only the number and the name for display. You'll have a design like this: Code: -- Item ID database item_id item_property_id int(15) int(15) -- Property Database property_id property_name property_value int(15) varchar(255) varchar(255) Linking both databases, you would only retrieve the info you wanted, when you want to. Not the complete database with all your information. It's the way that suits me best at the moment, but it might be a little bit exaggerated. I think Salathe - the guru - will be better at this than me but who cares. My point of view. __________________ "Life is a bitch, take that bitch on a ride"