Re: Nested database loops and completing an unordered list....

Thanks FeIn, I'll give these articles and methods a look this afternoon. I'm sure that it will lead to more questions, so I'll be back. On 3/1/2012 9:16 AM, FeIn wrote:

And see also this, which focuses only on the database part of the problem: http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/ On Thu, Mar 1, 2012 at 5:08 PM, FeIn <acid24@gmail.com <mailto:acid24@gmail.com>> wrote:

    I don't how how you keep your data in your database but there is
    no need to issues that many queries to retrieve your data. From
    what I understand the data you want to display is hierarchical.
    Here's an article that will hopefully point you to a solution
    (there are more out there, some better than other, google mysql
    hierchical data or database hierarchical data). The article I was
    talking about is here:
    http://www.sitepoint.com/hierarchical-data-database/