TalkPHP - View Single Post - What is the best way to structure this database?

TexasMd91 · 06-13-2008, 06:51 AM

dschreck, that is exactly how I first created it, only problem is that monsters can drop more then one item at a time, also that certain item can be in more then one quantity. Just making 2 rows doesn't work because then I can't count the rows to see how many times it has been killed.

Example:

Code:

Ork dropped 1 bone, 6 gold, 1 ork skin.
Ork dropped 1 bone, 3 gold.

EDIT: I could keep in the monster table how many times its been killed and increase it every time.

06-13-2008, 06:51 AM	#5 (permalink)
TexasMd91 The Wanderer Join Date: Jun 2008 Posts: 8 Thanks: 1	dschreck, that is exactly how I first created it, only problem is that monsters can drop more then one item at a time, also that certain item can be in more then one quantity. Just making 2 rows doesn't work because then I can't count the rows to see how many times it has been killed. Example: Code: Ork dropped 1 bone, 6 gold, 1 ork skin. Ork dropped 1 bone, 3 gold. EDIT: I could keep in the monster table how many times its been killed and increase it every time.