Hello. I'm trying to build an application but I'm stuck on designing the DB. I'll try
to explain how the site is going to be made, and hopefully someone can help.
There are only going to be 3 levels of pages. Category pages, sub pages, and sub-sub
pages. I want to be able to call any page, whether it's a sub-sub, sub, or category
page, just by it's id (like pageid=3).
Then, using only the pageid information I want to be able to get all the other pages
in that category... so, for example:
If pageid 3 was a sub-sub page... when someone goes to that page, I want to be able to
list the main category page it's under, the sub pages under that category, and then
the sub-sub pages under the sub page (which the current page belongs to). Can anyone
help me figure out how I should build the DB to handle this?
I feel like an idiot because it seems like it would be so simple (especially since I
know the pages will always be only 3 levels deep) but I just can't figure out how to
make the DB. Please help!
Cody
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
