building a menu from 2 arrays

[Anon]

Hi,
I wonder if someone can help me along.
I'm making a menu system, using a mysql table called category.
It consists of : category_id, category_name and category_hierarchy
all menu items and submenu items are listed in this table.

Now what I do is:
I loop through the results from a query that shows all main menu items. but I would also like to loop through a query of my submenu items at the same time and print them as:

-mainmenu item 1
-submenu item 1
-submenu item 1

-mainmenu item 2
-submenu item 2

-mainmenu item 3
-submenu item 3
-submenu item 3
-submenu item 3

-mainmenu item 4

-mainmenu item 5

Can anybody offer a few tips?

regards,

Mike

[johnh]

Looks like you could use a --
while (getting array elements)
{
for ($i=0; $i < total; $i++)
{
read in - sub elements
}
}

????
John