Comments by Jinxx1983 (Top 4 by date)

Ok, so I just copied an pasted the recursive sql to a new procedure in MySQL workbench and I get a syntax error unexpected @ in the line declare @id int = 1; I don't know sql very well, just the basics so not sure what to do to fix it.
I've continued to search around and found a recursive php solution at http://stackoverflow.com/questions/3116330/recursive-categories-with-a-single-query which I have adapted and seems to get my array sorted properly. So my issue now is writing the xml file in the correct order. I'll keep playing with the sql stored procedure and see if i can get it to work.

Thank I have just read your article, it is very useful, but I need to write the XML file. If I use the recursive query it looks like that will give me the results with each level the folder is at. I'll have a play with with that and I think I can use it make my XML file. I'm not sure how to execute the recursive SQL code in PHP though :S

Thank you for your reply, I have added the SQL table structure and the code I use to pull it out of SQL to the post.