This is script designed for building trees.

tree.lib.php - main library
tree_cat.sql - table dump
dbmysql.class.php - class for working with mysql database

Example of using:


<?php
require_once("tree.lib.php");
require_once("dbmysql.class.php");


define("DB_NAME", "mysql");
define("DB_HOST", "localhost");
define("DB_USER", "root");
define("DB_PASS", "");

$db = new DbMySQL(DB_HOST, DB_NAME, DB_USER, DB_PASS);
$db->connect();

$query = "SELECT
            *
          FROM
            mysql.categories
          ";

$categories = $db->select($query);



$tree = array();
build(0, $tree, $categories);

$res = "<categories>";
buildXML($tree, $res);
$res .= "</categories>";

?>