Ordering as tree?

From: Mika Halttu <ojmiha_at_uta.fi>
Date: 10 Aug 1999 15:03:52 GMT
Message-ID: <7opf0o$m2l$1@baker.cc.tut.fi>

Ordering table as a tree

Sample:
Table sructure

---

ID (Counter)

---

Parent (Points to Parents ID)

---

Name (text)

---

Level (Integer)

---

Question: Every record can have multiple (or none) "children", every record can have only one or none parents. How can I order this table as a tree, like a directory structure, for example?

Mika

--
--

Mika Halttu,
Summer '99: tel. +358-(0)50-5500678 fax. +358-(0)50-85500678 # t. mobile +358 - (0)41 - 5113974
e-mail: mika.halttu@uta.fi , http://www.uta.fi/~ojmiha/ Journalism Research Centre, http://www.uta.fi/jourtutkimus/ Dept. of Journalism and Mass Communication, University of Tampere P.O. Box 607, FIN-33101 Tampere, Finland Received on Tue Aug 10 1999 - 10:03:52 CDT