$id=0;
i=0;
$id=输入值;
$result=mysql_query("select * from tab where id=$id");
array[]=mysql_fetchrow($result);
array1[i]=array[1];
while(array[2]!=-1)
{
$id=array[2]
$result=mysql_query("select * from tab where id=$id");
array[]=mysql_fetchrow($result));
i++;
array1[i]=array[1];
}
for(j=i;j>=0;j--)
{
for(k=0;k<=i-j;k++){echo " ";}
echo array1[j];
}
i=0;
$id=输入值;
$result=mysql_query("select * from tab where id=$id");
array[]=mysql_fetchrow($result);
array1[i]=array[1];
while(array[2]!=-1)
{
$id=array[2]
$result=mysql_query("select * from tab where id=$id");
array[]=mysql_fetchrow($result));
i++;
array1[i]=array[1];
}
for(j=i;j>=0;j--)
{
for(k=0;k<=i-j;k++){echo " ";}
echo array1[j];
}
中node方法
<?php
$conn = mysql_connect();
mysql_select_db("test");
tree(7);function tree($ido,$k=0) {
static $ar = array();
$rs = mysql_query("select * from tab where id=$ido");
while(list($id,$title,$fid) = mysql_fetch_row($rs)) {
array_unshift($ar,$title);
tree($fid,1);
}
if($k==0) {
for($i=0;$i<count($ar);$i++)
echo str_repeat(" ",$i).$ar[$i]."<br>";
$rs = mysql_query("select * from tab where fid=$ido");
while(list($id,$title,$fid) = mysql_fetch_row($rs)) {
echo str_repeat(" ",$i).$title."<br>";
}
}
return;
}
?>
-1
1以上是当id=1时的结果