best way to store and call this data
Posted: Mon Jul 19, 2010 10:14 am
Ok the data I need to create a table for and store is the following:
Object 1
prcode
colour 1 through to colour 7
prices 1 through 7
Object 2
prcode
colour 1 through to colour 10
prices 1 through 10
Object 3
prcode
Pack 1 through 4
prices 1 through 4
items in packs 1 through 4
Whats the best way to store these in a Database, and then be able to pull themup on a webpage in an array (so that 1 option can be selected of each object) I've not done normalisation and database structure for quite some time, and I would like the make this really simple.
The colours will be storing a filepath for an image, the Packs will store the name of the pack and a list of whats in it.
Given it a go and realised I'm jsut going to make a hash of it with no advice, I started with Object 1, adding prcode, colour1, price 1, colour2, price2 etc etc through til the end, all field names and realised this may just not work when it comes to pulling the information out on the page in an Array (which I am terrible at anyway!)
Any help would be awesome,
Cheers,
Aravona
Object 1
prcode
colour 1 through to colour 7
prices 1 through 7
Object 2
prcode
colour 1 through to colour 10
prices 1 through 10
Object 3
prcode
Pack 1 through 4
prices 1 through 4
items in packs 1 through 4
Whats the best way to store these in a Database, and then be able to pull themup on a webpage in an array (so that 1 option can be selected of each object) I've not done normalisation and database structure for quite some time, and I would like the make this really simple.
The colours will be storing a filepath for an image, the Packs will store the name of the pack and a list of whats in it.
Given it a go and realised I'm jsut going to make a hash of it with no advice, I started with Object 1, adding prcode, colour1, price 1, colour2, price2 etc etc through til the end, all field names and realised this may just not work when it comes to pulling the information out on the page in an Array (which I am terrible at anyway!)
Any help would be awesome,
Cheers,
Aravona