What a load of arrays

[onlyican]

Hey

Now, this is going to be a bit confusing

I have 4 MySQL Tables

[b]Product[/b]
Product information such as Product name, Dimensions Ect
AND
A ProductSeries ID

[b]ProductSeries[/b]
ProductSeriesID Linking to products
And the Name of the ProductSeries
and a ProductRangeID

[b]ProductRange[/b]
ProductRangeID linking to ProductSeries
and the Name of the ProductRange
and a PrdouctGroupID


[b]ProductGroup[/b]
ProductGroupID linking to ProductRange
The Name of the ProductGroup

Now, thats pretty much how the database is set up

Say there are 10 Items under ProductGroup
Each item in ProductGroup has 10 items Under it from ProductRange

and Each ProductRange has an Item under it from ProductSeries

What I want to do is have a drop down box
That when you select a ProductGroup, A Selection box populats with ProductRange information
WHere the ProductGroup ID is the same as selected

now
TO have an array for each one could be a bit heavy
and to run a query for each ProductSeries will be heavy

SO what I am asking is the best way to get all the information for the database in arrays to get this to work

Just an added note,
Final figures at the moment, and this could go up
There are 196 Product Series
29 ProductRanges
12 Product Groups

[JasonLewis]

do you want the page to refresh and display the information. and i dont see what the problem with arrays are. they are useful for grouping the relitive information...

[onlyican]

I was hoping to do it without page refresh

but there is too much data to do that

[JasonLewis]

you cant use php to update a page without the browser refreshing. You would need to use javascript...

[TEENFRONT]

carnt you just call all the data into arrays on pageload and use linked dropdowns?

shouldnt be a problem with the arrays holding that much info..