I've got a query for a game I play.
First:
A creature table. This contains the unique # (just incremented) and the name of the creature.
Second table is creature location. This contains the unique #, again incremented, and the area its often found in.
The third is items.. basically their name and unique number.
Also, there is a table that I link the mob id to a location.
The last is item stats. It's the item id and certain stats. Since there are so many stats and not all items have all stats, and many are different numbers, ie: a bracelet could have a +1 strength and -1 dexterity, and no wisdom or endurance.
What I want to do is JUST draw the fields that are populated from the item table, so when I look up 'the bracelet', I JUST want "strength: +1, dexterity: +1" to show, and not the other blank stats.
Is this possible? Thanks!
First:
A creature table. This contains the unique # (just incremented) and the name of the creature.
Second table is creature location. This contains the unique #, again incremented, and the area its often found in.
The third is items.. basically their name and unique number.
Also, there is a table that I link the mob id to a location.
The last is item stats. It's the item id and certain stats. Since there are so many stats and not all items have all stats, and many are different numbers, ie: a bracelet could have a +1 strength and -1 dexterity, and no wisdom or endurance.
What I want to do is JUST draw the fields that are populated from the item table, so when I look up 'the bracelet', I JUST want "strength: +1, dexterity: +1" to show, and not the other blank stats.
Is this possible? Thanks!
