gj15987

I'm in the process of making a website in php on Reptiles and Amphibians. Just using free hosting while I'm making it. Address is http://herp.awardspace.com.

At the moment, I can add animals to the database and upload articles and those are searchable using the search box near the top right hand side.

I have one problem though. How do I categorize the animals?

Lets say I want to find a Royal Python...I'd put it under Reptiles > Snakes > Non-Venemous > Pythons.

On the site, if you navigate through all those it will indeed show a royal python. But I need it to also show up in the higher categories before that specific one. eg. The royal python will show up with all boa constrictors when viewing the non venemous category.

As it stands I have a category field in each animal record where I put its lowest category, in this case pythons.

I have a category table: category(id, name, parent). Parent being the parent category of that category.

Obviously this is not the right/ best way to do it so if any of that makes sense and anyone has any ideas I'd be greatful to hear them.



Thanks.