General Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsProgrammingGeneral Programming Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old May 7th, 2002, 07:18 AM
ozzie ozzie is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2002
Location: London
Posts: 11 ozzie User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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          |
+-------+----------+-------------------+
|     
|        General Knowledge |
|     
|        Transport         |
|     
|        Sport             |
|     
|        Golf              |
|     
|        Football          |
|     
|        Cars              |
|     
|        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

Reply With Quote
  #2  
Old May 8th, 2002, 03:05 PM
samscripts samscripts is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2002
Location: London, UK
Posts: 2 samscripts User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Hi,

the line
PHP Code:
#RETURN maketree($DBcatid,$level+1); 


should be
PHP Code:
 maketree($DBcatid,$level+1); 


I think. Otherwise, your while( list( etc etc) ) loop will only ever show the first item retrieved from the database because you return from the function after displaying it.

Sam

Reply With Quote
  #3  
Old May 9th, 2002, 04:09 AM
ozzie ozzie is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2002
Location: London
Posts: 11 ozzie User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thanks!!

Top Man Sam....

Much appreciated

Ozzie

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingGeneral Programming Help > Recursive Function gone West!!


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.

© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap