Tree-like data relationships are common, but working with trees in SQL usually requires awkward recursive queries. This talk describes alternative solutions for modeling hierarchical data that work for MySQL, including:
Code examples will demonstrate using the Closure Table in PHP, and offer guidelines for choosing one design over another.
For general inquiries, please send us your question and someone will contact you.