[PHP-DB] Trying to make site map

2010-01-03 Thread Zach Hicken
I am trying to create a ui for a page management script. During this step the user chooses which existing page the new page will link under. Each record has a field called Page_Above, which references the primary key number (id) of the page above it. Currently I have 4 records in the

[PHP-DB] Re: Trying to make site map

2010-01-03 Thread Brian Smither
It breaks apart when I try to go on the third level. On the second iteration of $secpageArray, it fetches Row4 from the database. Because there is no Page_Above that equals 4 (that is, no child of Page 4 in your map), the level 3 query might be coming back as False (no records returned), which

[PHP-DB] Re: Trying to make site map

2010-01-03 Thread Brian Smither
It breaks apart when I try to go on the third level. =Sorry, my email client didn't word-wrap.== On the second iteration of $secpageArray, it fetches Row4 from the database. Because there is no Page_Above that equals 4 (that is, no child of Page 4 in your map), the level 3 query might be coming

Re: [PHP-DB] Trying to make site map

2010-01-03 Thread Simcha Younger
On Mon, 21 Dec 2009 14:53:58 -0700 Zach Hicken z...@zhdesigns.com wrote: You are going to end up with alot of repetitous code if you repeat the process for every level. I would instead select all page data, and then construct a nested array to show the page structure, and then work off of that.

Re: [PHP-DB] Trying to make site map

2010-01-03 Thread Zach Hicken
Thank you very much On Jan 3, 2010, at 11:42 AM, Simcha Younger wrote: On Mon, 21 Dec 2009 14:53:58 -0700 Zach Hicken z...@zhdesigns.com wrote: You are going to end up with alot of repetitous code if you repeat the process for every level. I would instead select all page data, and then