[Resolved] looping...

[stevesweetland]

i have a mysql table.

ID    Name            ParentID
 1     Section 1           0
 2     Section 2           0
 3     Section 2a         2
 4     Section 2b         2
 5     Section 2ba       4

Idea being that this will lead to a practically unlimited breadcrumbing....

anyway - the question i have is looping this table.

i want to get this result in a dropdown box

value    label
   1       section 1
   2       section 2
   3       section 2 -> section 2a
   4       section 2 -> section 2b
   5       section 2 -> section 2b -> section 2ba

now, i cant be sure how many levels of sections there will be, otherwise id do this :

SELECT * FROM Sections WHERE Parent = '0' // get the top level first
while (next_record()){
  $sectionid = field(ID)
  $sectionname = field(Name)
  SELECT * FROM Sections WHERE Parent = '$sectionid'
  while (next_record()){
    etc....
  };
};

..yes i know that this isnt the correct syntax - just to give you an idea. this would only cater for a two level system, not an unlimited system, which is required.

i need to automatically loop all possible levels.

ideas on a postcard please....

[mrhappiness]

either you do it recursive or you make two tables

table1: menu_id | parent_id | description | ...

table2: menu_id | parent_id

if you have points 1, 1.a and 1.a.i you do something like that:
table1
1 | 0 | 1
2 | 1 | 1.a
3 | 2 | 1.a.i

table2
1 | 0
2 | 1
2 | 0
3 | 2
3 | 1
3 | 0

the SELECT to get the structure out fromthis is up to you 🙂

[bubblenut]

You need kiss from the recusion princess, however as she's away right now you'll have to settle for me... Pucker up!!

<?php

function getLinks($parentID) {
  //I'll assume you've connected to the db earlier
  global $conn; 
  $sql="SELECT * FROM sections WHERE Parent='".$parentID."'";
  $res=mysql_query($sql, $conn);
  for($i=0;$res=mysql_fetch_array($res)$i++) {
    $result[$i]['ID']=$row['ID'];
    $result[$i]['label']=$row['label'];
    $result[$i]['children']=getLinks($row['ID']);
 }
  return $result;
}

$BreadcrumbArray=getLinks(0);
?>

Right you will be left with an array, $breadcrumbArray of the form

Array
( 
  [0] => Array
    ( 
      [ID] => 1 
      [label] => section 1 
      [children] => 
    ) 
  [1] => Array
    ( 
      [ID] => 2 
      [label] => section 2 
      [children] => Array
        (
          [0] => Array
            (
               [ID] => 3
               [label] => section 3
               [children] => Array .......

HTH
Bubble

[stevesweetland]

Originally posted by bubblenut
You need kiss from the recusion princess, however as she's away right now you'll have to settle for me... Pucker up!!

see what you're getting at - im trying to stray away from arrays. i see what you mean - ill try to adapt your idea to my requirement - thanks a lot, much appreciated.