Nav question

[Anon]

Hi Guys,
If you goto http://www.onlymelbourne.com.au/trial1.php i have put up an example so as to better understand my question.
You will see 3 categories, If you click on Art for example it goes to trial2.php .....all this works fine.
However, if you click on one of the sub categories (lets say Paintings), it takes you to trial3.php
What i need to know is how can i get the second link (Paintings) to display the title Art (from the previous page).
Therefore, trial3.php show look like: Home > Art > Paintings with the first to being links back to their respective pages.

Any ideas?
Cheers,
mel

[Anon]

How are you storing the ID? Do you store the parents of each ID?

For example :

Category ID Parent
Arts 1 null
Paintings 2 1
Sculptures 3 1

If you do something like that, you can get all the parents, until you reach null (which would mean top level) and display each parent.

Diego

[Anon]

Sorry, i was meant to include my table structure. Here it is anyway:

CatID CatName CatParent

1 Art

2 Computers

3 Religion

4 Dynamic HTML 2

5 E-Commerce 2

6 Graphics 2

7 Internet 2

8 Javascript 2

9 Perl 2
10 Web Design 6

11 Paintings 1

12 Sculpture 1