May 7th, 2002, 06:18 AM
|
|
Junior Member
|
|
Join Date: May 2002
Location: London
Posts: 11
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Recursive Function gone West!!
Hello,
I've got this function called maketree which passes two values.
I know I've posted a query similar, but now making progress with this!!
PHP Code:
<?
function maketree($rootcatid,$level)
{
echo $level;
$sql="select catid,cat_name
from quiz_category
where parentid=$rootcatid
order by cat_name";
#echo "$sql<br>\n";
$result=mysql_query($sql);
while (list($DBcatid,$DBcatname)=mysql_fetch_row($result ))
{
$width=($level+1)*24;
$display="<img src=e.gif width=$width height=12>";
$display.="$DBcatname";
$display.="<input type=\"radio\" name=\"quest_type\" value=$DBcatid><br>\n";
echo $display;
#RETURN maketree($DBcatid,$level+1);
}
}
?>
<?
maketree(0,0);
?>
Whats happening here is that it displays:
PHP Code:
General Knowledge
Sport
Football
but it should display:
PHP Code:
General Knowledge
Sport
Football
Golf
Transport
Cars
trains
Contents of table.....
PHP Code:
+-------+----------+-------------------+
| catid | parentid | cat_name |
+-------+----------+-------------------+
| 1 | 0 | General Knowledge |
| 2 | 1 | Transport |
| 3 | 1 | Sport |
| 4 | 3 | Golf |
| 5 | 3 | Football |
| 6 | 2 | Cars |
| 7 | 2 | Trains |
+-------+----------+-------------------+
Where am I going wrong with the function?? Any assitance greatly received...
If I figure it out before anyone does then I will post up the correct version.
Thanks all
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
