[Resolved] create categories trees

[searain]

categories table

categoies_id, parent_id
1, 0
2, 0
3, 0
4, 2
5, 2
6, 5

I want to create a categoies tree (use in drop down menu), make it like

1
2
--4
--5
----6
3

I guess it is a function/feature used very often in the e-commerce catalog, forum tree structure.

Is there a good function/class (php scripts) you can recommend that I can use to do the above work?

Thanks!

[leatherback]

try this:

$menuquery = "select * from menu order by M_sortorder asc";

$result=mysql_query($menuquery) or die('An error occured retrieving data');

$listing = Array();


while($row = mysql_fetch_array($result))
  { 
  $listing[] = array("This_id"        => $row[M_page_nr], 
                     "path"           => $row[M_path],
                     "parent_id"      => $row[M_p_nr],    

                     "category_title" => $row[M_label], 
                     "link"           => $row['M_link']
                     );
  }

function display_tree($parent, $level, $array, $path)
{

foreach ($array AS $node)

  if($node[parent_id]==$parent)
    {
    $html .= "
    <a class=\"menu".$level."\" href=\"$path$node[path]$node[link]\">".$node[category_title]."</a>
    ";
         $html .= display_tree($node[This_id], ($level + 1), $array, $path);
    }

//  }

  return $html;

} // end display list


// Now use it

$menu = display_tree(0, 0, $listing, $baseurl);  

[searain]

Great. Thanks a lot!

[robtbs]

leatherback thanks sooo much,
that function has solved my on going need for almost unlimited sub categories!!!!

Excellent!!

[leatherback]

NP,

Happy it helped.

[Rayman3_tk]

This is brilliant, just what i sought! Thanks! 🙂