MySQL - Recursing a tree structure
hierarchy, mysql, recursion
Solution
There's a good-looking article over at mysql.com outlining various ways of managing hierarchical data. I think it provides a full solution to your question, and shows various less simple, but faster approaches (e.g. Nested Sets).
Problem
I have a database table which link locations together; a location can be in a location, which can be inside another location. ``` location (<id>, ....) location_parent (<location_id>, <parent_id>) ``` Here's the MySQL/PHP to go down for a depth of one: ``` $sql = "SELECT id FROM se_locations_services WHERE parent_locationid IN ( SELECT location_id FROM se_locations_parent WHERE parent_id = '$locationid' )"; ``` How do I, given a parent location, gets all its descendants locations, no matter how deep, just using MySQL?