如何在php中编辑/管理多层条件数据

Question

I have 4 tables in a mysql database that i need to add/edit/manage.

The difficulty, is that each one, is dependent on the one before it.

The way i have this setup on the user end, is you select an option from table 1. You are then presented with the options in table 2, that have the first option's ID in their row. Once you select option in table 2, you are taken to table 3, which generates its list where the rows contain the ID of your selection in table 2, and so on and so forth.

The problem is how to edit/manage this.

Obviously if you delete an option in table 1, all its subsequent child options will be invalid.

I just need an idea of how to manage a setup like this.

Answer 1

Multi-tiered data is most-often stored in with a parent:child relation field in a table.

id  | name | parent_id
----------------------
1   | Mom  | NULL
2   | Son  | 1

Write a recursive function/query to traverse the relationships and any updates/inserts/deletes should be relatively simple.