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@xxxxxxxxx
<mailto:acid24@xxxxxxxxx>> 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/
