PHP Array to Menu

[iteach2]

Guru's,

Once again I need your help please. I have three arrays each array is based on its own database quiery - select * from ____

1 array. Departments
2 array. Category
3. array. Subcategory

It looks like this:

Array
(
    [0] => Array
        (
            [DepID] => 10015
            [Department] => Ammunition
        )

    [1] => Array
        (
            [DepID] => 10024
            [Department] => Black Powder 
        )

    [2] => Array
        (
            [DepID] => 10036
            [Department] => Cutlery & Tools
        )

    [3] => Array
        (
            [DepID] => 10012
            [Department] => Handguns
        )

    [4] => Array
        (
            [DepID] => 10023
            [Department] => Holsters
        )

    [5] => Array
        (
            [DepID] => 10020
            [Department] => Lights & Lasers
        )

    [6] => Array
        (
            [DepID] => 10010
            [Department] => Long Guns
        )

    [7] => Array
        (
            [DepID] => 10034
            [Department] => Magazines & Clips
        )

    [8] => Array
        (
            [DepID] => 10014
            [Department] => Optics, Rangefinders & Sights
        )

    [9] => Array
        (
            [DepID] => 10029
            [Department] => Personal Protection
        )

    [10] => Array
        (
            [DepID] => 10035
            [Department] => Slings & Swivels
        )

)

----------------------------------------------------------------------------------------------------------------------------------------------------------
Array
(
    [0] => Array
        (
            [CatID] => 20061
            [DepID] => 10024
            [Category] => Accessories
        )

    [1] => Array
        (
            [CatID] => 20127
            [DepID] => 10020
            [Category] => Accessories
        )

    [2] => Array
        (
            [CatID] => 20173
            [DepID] => 10034
            [Category] => Belts
        )

    [3] => Array
        (
            [CatID] => 20045
            [DepID] => 10014
            [Category] => Binoculars
        )

    [4] => Array
        (
            [CatID] => 20042
            [DepID] => 10010
            [Category] => Centerfire Rifles
        )

    [5] => Array
        (
            [CatID] => 20177
            [DepID] => 10023
            [Category] => Civilian
        )

    [6] => Array
        (
            [CatID] => 20174
            [DepID] => 10034
            [Category] => Clips
        )

    [7] => Array
        (
            [CatID] => 20043
            [DepID] => 10010
            [Category] => Combo Guns
        )

    [8] => Array
        (
            [CatID] => 20099
            [DepID] => 10036
            [Category] => Cutlery & Tool Accessories
        )

    [9] => Array
        (
            [CatID] => 20137
            [DepID] => 10029
            [Category] => Defense Sprays
        )

    [10] => Array
        (
            [CatID] => 20040
            [DepID] => 10012
            [Category] => Derringer
        )

    [11] => Array
        (
            [CatID] => 20138
            [DepID] => 10029
            [Category] => Electric Protection
        )

    [12] => Array
        (
            [CatID] => 20153
            [DepID] => 10036
            [Category] => Fishing
        )

    [13] => Array
        (
            [CatID] => 20124
            [DepID] => 10020
            [Category] => Flashlights
        )

    [14] => Array
        (
            [CatID] => 20052
            [DepID] => 10015
            [Category] => Handgun
        )

    [15] => Array
        (
            [CatID] => 20059
            [DepID] => 10024
            [Category] => Handguns
        )

    [16] => Array
        (
            [CatID] => 20090
            [DepID] => 10034
            [Category] => Handguns
        )

    [17] => Array
        (
            [CatID] => 20154
            [DepID] => 10036
            [Category] => Hunting & Outdoor
        )

    [18] => Array
        (
            [CatID] => 20125
            [DepID] => 10020
            [Category] => Lasers
        )

    [19] => Array
        (
            [CatID] => 20086
            [DepID] => 10023
            [Category] => Law Enforcement
        )

    [20] => Array
        (
            [CatID] => 20058
            [DepID] => 10024
            [Category] => Long Guns
        )

    [21] => Array
        (
            [CatID] => 20172
            [DepID] => 10034
            [Category] => Long Guns
        )

    [22] => Array
        (
            [CatID] => 20156
            [DepID] => 10036
            [Category] => Military & Law Enforcement
        )

    [23] => Array
        (
            [CatID] => 20049
            [DepID] => 10014
            [Category] => Night Vision
        )

    [24] => Array
        (
            [CatID] => 20036
            [DepID] => 10012
            [Category] => Pistol
        )

    [25] => Array
        (
            [CatID] => 20152
            [DepID] => 10036
            [Category] => Pocket
        )

    [26] => Array
        (
            [CatID] => 20181
            [DepID] => 10024
            [Category] => Precussion Caps, Primers, Flints, and Accessories
        )

    [27] => Array
        (
            [CatID] => 20178
            [DepID] => 10024
            [Category] => Propellants
        )

    [28] => Array
        (
            [CatID] => 20164
            [DepID] => 10014
            [Category] => Rangefinders
        )

    [29] => Array
        (
            [CatID] => 20037
            [DepID] => 10012
            [Category] => Revolver
        )

    [30] => Array
        (
            [CatID] => 20054
            [DepID] => 10015
            [Category] => Rifle
        )

    [31] => Array
        (
            [CatID] => 20163
            [DepID] => 10010
            [Category] => Rimfire Rifles
        )

    [32] => Array
        (
            [CatID] => 20055
            [DepID] => 10015
            [Category] => Rimfire, Blanks & Training Rounds
        )

    [33] => Array
        (
            [CatID] => 20180
            [DepID] => 10024
            [Category] => Round Balls, Bullets, and Sabots
        )

    [34] => Array
        (
            [CatID] => 20044
            [DepID] => 10014
            [Category] => Scopes
        )

    [35] => Array
        (
            [CatID] => 20056
            [DepID] => 10015
            [Category] => Shotgun
        )

    [36] => Array
        (
            [CatID] => 20041
            [DepID] => 10010
            [Category] => Shotguns
        )

    [37] => Array
        (
            [CatID] => 20048
            [DepID] => 10014
            [Category] => Sights
        )

    [38] => Array
        (
            [CatID] => 20039
            [DepID] => 10012
            [Category] => Single Shot
        )

    [39] => Array
        (
            [CatID] => 20100
            [DepID] => 10035
            [Category] => Slings
        )

    [40] => Array
        (
            [CatID] => 20097
            [DepID] => 10036
            [Category] => Specialty
        )

    [41] => Array
        (
            [CatID] => 20046
            [DepID] => 10014
            [Category] => Spotting Scopes
        )

    [42] => Array
        (
            [CatID] => 20101
            [DepID] => 10035
            [Category] => Swivels
        )

    [43] => Array
        (
            [CatID] => 20096
            [DepID] => 10036
            [Category] => Tools
        )

    [44] => Array
        (
            [CatID] => 20155
            [DepID] => 10036
            [Category] => Utility/Specialty
        )

    [45] => Array
        (
            [CatID] => 20157
            [DepID] => 10036
            [Category] => Water Sports
        )

)

-----------------------------------------------------------------------------
Array
(
    [0] => Array
        (
            [SubID] => 30510
            [CatID] => 20086
            [SubCategory] => Accessories Pouches
        )

    [1] => Array
        (
            [SubID] => 30194
            [CatID] => 20125
            [SubCategory] => Aiming Lasers
        )

    [2] => Array
        (
            [SubID] => 30549
            [CatID] => 20137
            [SubCategory] => Animal
        )

    [3] => Array
        (
            [SubID] => 30508
            [CatID] => 20177
            [SubCategory] => Ankle
        )

    [4] => Array
        (
            [SubID] => 30479
            [CatID] => 20155
            [SubCategory] => Axes
        )

    [5] => Array
        (
            [SubID] => 30259
            [CatID] => 20127
            [SubCategory] => Batteries
        )

    [6] => Array
        (
            [SubID] => 30471
            [CatID] => 20097
            [SubCategory] => Bayonets
        )

    [7] => Array
        (
            [SubID] => 30514
            [CatID] => 20177
            [SubCategory] => Belly Bands
        )

    [8] => Array
        (
            [SubID] => 30515
            [CatID] => 20177
            [SubCategory] => Belt Holster
        )

    [9] => Array
        (
            [SubID] => 30509
            [CatID] => 20086
            [SubCategory] => Belt Holster
        )

    [10] => Array
        (
            [SubID] => 30317
            [CatID] => 20045
            [SubCategory] => Birding/Travel/Theatre
        )

    [11] => Array
        (
            [SubID] => 30026
            [CatID] => 20055
            [SubCategory] => Blanks
        )

    [12] => Array
        (
            [SubID] => 30296
            [CatID] => 20042
            [SubCategory] => Bolt Action
        )

    [13] => Array
        (
            [SubID] => 30305
            [CatID] => 20163
            [SubCategory] => Bolt Action
        )

    [14] => Array
        (
            [SubID] => 30482
            [CatID] => 20172
            [SubCategory] => Box Magazines
        )

    [15] => Array
        (
            [SubID] => 30090
            [CatID] => 20061
            [SubCategory] => Breach Plugs, Wedge Pins, Wedge Pullers, and Priming Tools
        )

    [16] => Array
        (
            [SubID] => 30258
            [CatID] => 20127
            [SubCategory] => Bulbs
        )

    [17] => Array
        (
            [SubID] => 30089
            [CatID] => 20061
            [SubCategory] => Bullet Starters and Ram Rods
        )

    [18] => Array
        (
            [SubID] => 30542
            [CatID] => 20180
            [SubCategory] => Bullets
        )

    [19] => Array
        (
            [SubID] => 30110
            [CatID] => 20059
            [SubCategory] => Cap & Ball
        )

    [20] => Array
        (
            [SubID] => 30091
            [CatID] => 20061
            [SubCategory] => Cappers and Decappers
        )

    [21] => Array
        (
            [SubID] => 30477
            [CatID] => 20155
            [SubCategory] => Carbiner Knives
        )

    [22] => Array
        (
            [SubID] => 30318
            [CatID] => 20054
            [SubCategory] => Centerfire
        )

    [23] => Array
        (
            [SubID] => 30351
            [CatID] => 20052
            [SubCategory] => Centerfire
        )

    [24] => Array
        (
            [SubID] => 30008
            [CatID] => 20036
            [SubCategory] => Centerfire
        )

    [25] => Array
        (
            [SubID] => 30010
            [CatID] => 20040
            [SubCategory] => Centerfire
        )

    [26] => Array
        (
            [SubID] => 30267
            [CatID] => 20039
            [SubCategory] => Centerfire
        )

    [27] => Array
        (
            [SubID] => 30195
            [CatID] => 20037
            [SubCategory] => Centerfire
        )

    [28] => Array
        (
            [SubID] => 30263
            [CatID] => 20127
            [SubCategory] => Chargers
        )

    [29] => Array
        (
            [SubID] => 30290
            [CatID] => 20043
            [SubCategory] => Combos
        )

    [30] => Array
        (
            [SubID] => 30535
            [CatID] => 20178
            [SubCategory] => Compressed Powder
        )

    [31] => Array
        (
            [SubID] => 30550
            [CatID] => 20181
            [SubCategory] => Conversion Kits
        )

    [32] => Array
        (
            [SubID] => 30516
            [CatID] => 20177
            [SubCategory] => Crossdraw
        )

    [33] => Array
        (
            [SubID] => 30487
            [CatID] => 20173
            [SubCategory] => Disintegrating
        )

    [34] => Array
        (
            [SubID] => 30485
            [CatID] => 20172
            [SubCategory] => Drum, Pan & Helical Magazines
        )

    [35] => Array
        (
            [SubID] => 30115
            [CatID] => 20058
            [SubCategory] => Electronic Ignition
        )

    [36] => Array
        (
            [SubID] => 30491
            [CatID] => 20174
            [SubCategory] => En Bloc Clips
        )

    [37] => Array
        (
            [SubID] => 30221
            [CatID] => 20046
            [SubCategory] => Field Spotting Scopes
        )

    [38] => Array
        (
            [SubID] => 30174
            [CatID] => 20153
            [SubCategory] => Fixed
        )

    [39] => Array
        (
            [SubID] => 30175
            [CatID] => 20154
            [SubCategory] => Fixed
        )

    [40] => Array
        (
            [SubID] => 30178
            [CatID] => 20156
            [SubCategory] => Fixed
        )

    [41] => Array
        (
            [SubID] => 30488
            [CatID] => 20157
            [SubCategory] => Fixed
        )

    [42] => Array
        (
            [SubID] => 30088
            [CatID] => 20061
            [SubCategory] => Flasks, Funnels,  Powder Measures and Quick Loaders
        )

    [43] => Array
        (
            [SubID] => 30112
            [CatID] => 20058
            [SubCategory] => Flint Lock
        )

    [44] => Array
        (
            [SubID] => 30546
            [CatID] => 20181
            [SubCategory] => Flints
        )

    [45] => Array
        (
            [SubID] => 30489
            [CatID] => 20157
            [SubCategory] => Folding
        )

)

What Im trying to do is combine them into one are array with Parent/Child/Subchild structure.

Like This:

Department(Parent)
Category(Child)
Subcategory(Subchild)

Im thinking They can be splitup/linkedup by the ID'S - I just havent figured out how to do it.

Department(Parent)(DEPID)
  Category(Child)(DEPID,CATID)
    Subcategory(Subchild)(CATID,SUBID)

Im try to build a navigation - please help

 

[jpadie]

run your queries iteratively.

i.e. as you construct your result set for the first query, create a query for each row. similar as you construct your second level of the array, create a third query.

you end up with a large number of queries but each will return a small amount of data. not too troublesome.

alternatively you could just walk the arrays doing much the same thing.

and lastly you could most probably construct your requirements in a single query and have your results array made for you in one swoop.