RE: Hierarchical trees in MySQL

2001-08-19 Thread Jay at Work
Or just a string "Main2/Child2-1/Child2-2-1"... Any ideas? Are they just rumours that this cannot be made with MySQL without any accessories, PHP etc? The problem I had with trying to implement this type of solution for a threaded discussion app was in 'most recent' sorting. I want the Parent

Hierarchical trees in MySQL

2001-08-18 Thread Ville Mattila
Hi there, I have heard that MySQL has some special functions or it's some other way capable to handle hierarchical forms in table. Let me give an example: Table contains following rows: IDNameParentID 1Main10 2Main20 3Main30 4Child1-11 5Child2-12