raj_2006
10-15-2008, 12:11 AM
Hi All,
I got this following tree structure code in this forum after searching.But I like to change the display.
I would like to display like this:
1
2 3
4 6
5 7
Code:
function recursive($results){
if(!is_resource($results)){
$sql = "SELECT * FROM `tab` WHERE `parent` = '".$results."' ORDER BY id;";
$results = mysql_query($sql);
}
$return = Array();
while(($row = mysql_fetch_assoc($results)) !== false){
$return[] = $row;
$sql = "SELECT * FROM `tab` WHERE `parent` = '".$row['id']."' ORDER BY id;";
$results2 = mysql_query($sql);
if(mysql_num_rows($results2) > 0){
$return[count($return)-1]['parent'] = recursive($results2);
}
}
return $return;
}
function tree($item, $key){
echo "<div style='float:left; margin:5px; '>".$item['id']."<br />\n";
array_walk(recursive($item['id']), 'tree');
echo "</div>\n";
}
$start = 1;
echo $start."<br />";
array_walk(recursive($start), 'tree');
Please suggest me how can i display like above
Thanks in advance.
Raj
I got this following tree structure code in this forum after searching.But I like to change the display.
I would like to display like this:
1
2 3
4 6
5 7
Code:
function recursive($results){
if(!is_resource($results)){
$sql = "SELECT * FROM `tab` WHERE `parent` = '".$results."' ORDER BY id;";
$results = mysql_query($sql);
}
$return = Array();
while(($row = mysql_fetch_assoc($results)) !== false){
$return[] = $row;
$sql = "SELECT * FROM `tab` WHERE `parent` = '".$row['id']."' ORDER BY id;";
$results2 = mysql_query($sql);
if(mysql_num_rows($results2) > 0){
$return[count($return)-1]['parent'] = recursive($results2);
}
}
return $return;
}
function tree($item, $key){
echo "<div style='float:left; margin:5px; '>".$item['id']."<br />\n";
array_walk(recursive($item['id']), 'tree');
echo "</div>\n";
}
$start = 1;
echo $start."<br />";
array_walk(recursive($start), 'tree');
Please suggest me how can i display like above
Thanks in advance.
Raj