Here's a start for you

<?
/* Connect to database */

$sql = "SELECT * FROM categories ORDER BY
parent_id,cat_id  ASC";

$result = @mysql_query($sql) or die("Couldn't select
categories."); 

$menu = array();

while ($row = mysql_fetch_array($result)) {
        $id = $row['cat_id'];
        $category = $row['category'];
        $pid = $row['parent_id'];
        
        $menu[$pid][$id] = $category;
}

function show_cats ($parent="", $indent="") {
global $menu;

foreach($menu as $key1 => $value1) {

        if ($key1 == $parent) {// if it's a top category
print it
        
                foreach ($value1 as $key2 => $value2) { 
                $catname = $value2; // $value2 same as
$value1[$key2]
                $catID = $key2;
                echo str_repeat("&nbsp;&nbsp;", $indent);
                echo "<a
href=\"search/show_results.php?catID=$catID\">$catname</a><br>";
                
show_cats($catID, $indent+1);
                }
                        
        }
}

} // end show_cats function

show_cats();
?> 

--- Boris Kolev <[EMAIL PROTECTED]> wrote:
> Hello php-general,
> 
>   Hi.
>   I want to know how i can export tree structure
> from Mysql table to
>   XML
>   mysql table structure is:
>   ID - Group Unique Id
>   P_ID - Parent Id
>   Name - Name of group
> 
>   I want to make XML whit tree structure. Can some
> body help me!
>   
> 
> -- 
> Best regards,
>  Boris                         
> mailto:[EMAIL PROTECTED]
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to