Its sounds as if you have the database set up correctly so you should be in good shape in that area. To display this I would query the db, and store all the rows in an array. Then take the array and search for the first main directory, then its sub categories and then the sub categories subs, and then move back to the next category and continue on like that. The reason for thearray is so that you are not having 8 or 12 queries to your db which would take a lot more time to run.

__________________
iSearchNotes.com - Share College Student Notes | Blog