Originally Posted by howard-moore
I'm currently only planning two levels, but may add another level in the future if it is viable.
This indicates that you'll need to use recursion (or a hellalot of querying within the recursion, which I don't recommend); alternatively in the OO world you could write a tree. I don't recommend writing it to match just the two levels if there is a possibility the depth will change (otherwise you could actually query it in a way that it builds the lists into a logical array with minimal PHP work, but it is tied down whatever level you query). Too bad RDBMS aren't recursive.
I'll try to write something up between work here today. The type column isn't necessary btw, I'll assume that a parent_page of either 0 or null would dictate whether it is located on top or not (I'll assume 0). Either case I'll typically create a root parent anyway since it makes the recursion easier.
BTW, what is this page content here? Is it actually a text type or something more along a title? You want to try and minimize the data per fetch if you can.