I am looking for the best way to set up a hierarchy within my database to make a directory.
Some categories will have more levels than others so what would be the best way to establish this for efficiency.
the best answer i know of (for mysql): Managing Hierarchical Data in MySQL
thanks dagon I had read about this method before but if MySQL says it is the way to go then I would have to accept that they would know best.
