Page 1 of 1

Operation on hierchical datas

Posted: Sun Nov 18, 2007 3:18 am
by PHPycho
Hello forums!!
I would like to know the queries required to operate on hierarchical datas like INSERT, SELECT, UPDATE, DELETE etc. so that the action can be done with one query.
My hierarchical data are contained in the table as:
|id|title|parent_id|description|
Thanks in advance for the suggestion.

Posted: Sun Nov 18, 2007 7:45 am
by feyd
The maximum you can retrieve at any given time is directly related to how many joins you perform to the same table in the query.

Hierarchical data is often stored with a different structure to ease the queries. Since they have been talked about so much, I'll let you search for them before saying anything further.