tree structure

[Dillenger]

I'm trying to setup a weird tree structure in MySQL, but need ALOT of help... there is the basic idea:

1. Project
      - category
           -category detail
      - category
           -category detail
      - category
           -category detail
2. Project
      - category
           -category detail
      - category
           -category detail
      - category
           -category detail
      - category
           -category detail

Now, Project (and all of its data) is stored in one table... category is stored in another table, and category details is stored in another table... so effectivaly I have 3 tables... Projects being the main, and category being referenced by it, and then category detail being referenced by category...

Also, there will be a variable amount of categoys in each project... for instance, one could have 6 and the next one could have 24 categories...

I have NO idea how to put this together in PHP to make it display as such, so any help would be greatly appreciated. All i know is that I should be referencing ID's from the other tables, but how to do that, i do not know.

[leatherback]

Hi,

Three tables: Project // Category // details

Project:
p_id // Projecvt ID number, autoincrement
p_name // Project name

Categories:
c_id // Category ID, autoincrement
c_p_nr // =p_id, identification number of the project to which this category belongs
c_name // Category name

Details:
d_id // Details ID, autoincrement
d_c_nr // =c_id, identification number of the category to which these details belongs
d_name // Category name

You can then

$results = mysql_query("Select * from project order by p_name") or die(mysql_error());

while($row = mysql_fetch_array($results))
  {
  echo $row[p_id];
  $query = "select * from cartegories where c_p_nr = p_id order by c_name";
  $categories  = mysql_query($query);
  while ($Cat_row = mysql_fetch_array($categories))
     {
      echo $cat_row[c_name];
      }
   }

The code is not perfect / complete, but should give you the basic ide.

Chers,

J.