>>>> 2012/05/25 10:07 -0500, AndrYou have a typical hierarchical data issue, can be solved with a graph.
Theory review: http://www.algorithmist.com/index.php/Graph_data_structures
Mysql and PHP implementation:
http://www.phpro.org/tutorials/Managing-Hierarchical-Data-with-PHP-and-MySQL.html
<<<<<<<<
>>>> 2012/05/25 11:31 -0500, Peter Brawley >>>>
It's a graph! See http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
<<<<<<<<
Of course--but does Haidar Pasabe want to see that?
**************************************************************
Scanned by MailScan AntiVirus and Content Security Software.
Visit http://www.escanav.com for more info on eScan and X-Spam.
**************************************************************