Re: tree structure

ng if somebody here already tried something like that or if it is a stupid idea Ian Gibbons wrote: On 18 Oct 2004 at 15:27, Melanie wrote: Hi, Does anybody has a simple idea to store a tree structure under mySQL 4.1.5? I have one table with id, familyType,superFamily,family, for example:

Re: tree structure

On 18 Oct 2004 at 15:27, Melanie wrote: > Hi, > Does anybody has a simple idea to store a tree structure under mySQL 4.1.5? > I have one table with id, familyType,superFamily,family, for example: Hi, This tutorial (PHP + MySQL) shows a few different methods: http://www.sitepoint.co

tree structure

Hi, Does anybody has a simple idea to store a tree structure under mySQL 4.1.5? I have one table with id, familyType,superFamily,family, for example: +-+---++ | id | familyId | accession | +-+---++ | 287 |22 | . | | 288

Traversing a tree structure in MySQL

I'm in the process of building a tree-structured message base, or rather porting software I wrote back in mid-80s to the web. This isn't the ubiquitous "threaded" BBS software. It's tree-structured. This means that every message on the message base is related through a single ancestor, Msg #