List:General Discussion« Previous MessageNext Message »
From:Daniel Łaś Date:October 22 2001 9:34pm
Subject:Tree in SQL
View as plain text  

I have a table in database which describes tree structure of article groups.
In this table I have:
1. group_id - group identifier
2. parent_group_id - identifier of parent group
I need to select history, from top to wanted group.
I can't change the database design and ofcourse this is MySQL 3.23 database.
Can somebody help me ?


Daniel Łaś
e-direct Polska sp. z o.o.
E-mail: daniel.las@stripped
45-072 Opole ul. Reymonta 45
tel. +48 77 44 26 073
fax. +48 77 44 26 074

Tree in SQLDaniel Łaś22 Oct
  • RE: Tree in SQLSteve Meyers23 Oct
    • ODP: Tree in SQLDaniel Łaś23 Oct
      • RE: Tree in SQLSteve Meyers23 Oct
  • Re: Tree in SQLDan Nelson24 Oct