RSS

Re: Report w/Cateories/subcategories

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Report w/Cateories/subcategories

•

Join Date: May 2007

Posts: 7

Reputation: tlei is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

tlei

Offline

Newbie Poster

Re: Report w/Cateories/subcategories

May 24th, 2007

•

Originally Posted by johny_d

Try this:
Help with Code Tags

php Syntax (Toggle Plain Text)
$query = "SELECT `order`.`order`,`order`.id as oid,genus.genus,genus.id as gid,species.species, species.id as sid FROM `order`, genus, species WHERE `order`.id =genus.order_id AND genus.id=species.genus_id";
$rows = mysql_query ($query);
 
while ($v  = mysql_fetch_assoc ($rows)) {
 $order[$v['oid']] = $v['order'];
 $genus[$v['oid']][$v['gid']] = $v['genus'];
 $species[$v['gid']][$v['sid']] = $v['species'];
 }
 
$result = "<ul>";
foreach ($order as $ko => $vo) {
 $result .= "<li>".$vo."\r\n <ul>\r\n";
 foreach ($genus[$ko] as $kg => $vg) {
  $result .= "  <li>".$vg."\r\n  <ul>\r\n";
  foreach ($species[$kg] as $ks => $vs) {
   $result .= "   <li>".$vs."</li>\r\n";
   }
  $result .= "  </ul></li>\r\n";
  }
 $result .= " </ul></li>\r\n";
 }
$result .= "</ul>\r\n";
 
echo $result;
$query = "SELECT `order`.`order`,`order`.id as oid,genus.genus,genus.id as gid,species.species, species.id as sid FROM `order`, genus, species WHERE `order`.id =genus.order_id AND genus.id=species.genus_id"; $rows = mysql_query ($query); while ($v = mysql_fetch_assoc ($rows)) { $order[$v['oid']] = $v['order']; $genus[$v['oid']][$v['gid']] = $v['genus']; $species[$v['gid']][$v['sid']] = $v['species']; } $result = "<ul>"; foreach ($order as $ko => $vo) { $result .= "<li>".$vo."\r\n <ul>\r\n"; foreach ($genus[$ko] as $kg => $vg) { $result .= " <li>".$vg."\r\n <ul>\r\n"; foreach ($species[$kg] as $ks => $vs) { $result .= " <li>".$vs."</li>\r\n"; } $result .= " </ul></li>\r\n"; } $result .= " </ul></li>\r\n"; } $result .= "</ul>\r\n"; echo $result;
It worked on my comp.

Thanks, johnny_d. When I applied your script to my db I couldn't make it work - I tried checking all the syntax and everything, but I get nothing. The tables and fields I'm actually using are:

Help with Code Tags

(Toggle Plain Text)

process [tbl]
   id [pk]
   process

step [tbl]
   id [pk]
   step
   process_id

substep [tbl]
   id [pk]
   substep
   step_id

...and here is the code I used, following your model

Help with Code Tags

(Toggle Plain Text)

$query = "SELECT process.process,process.id AS pid,
    step.step.step.id AS sid ,
    substep.substep,substep.id AS bid
        FROM process,step,substep 
        WHERE process.id =step.process_id 
        AND step.id=substep.step_id";
    
    $rows=mysql_query($query) or die(mysql_error());
    
    while($d=mysql_fetch_assoc($rows) {    
        $process[$d['pid']] = $d['process'];
        $step[$d['sid']] = $d['step'];
        $substep[$d['bid']] = $d['substep'];
    
        $result = "<ul>";
        
        foreach($process as $key_p => $val_p) {
            $result .= "<li>" . $val_p . "\r\n <ul>\r\n";
            
            foreach($step as $key_s => $val_s) {    
                $result .= "   <li>" . $val_s . "\r\n <ul>\r\n";
                
                foreach($substep as $key_b => $val_b) {
                    $result .= "      <li>" . $val_b . "\r\n <ul>\r\n";
                    }
                $result .= "     </ul></li>\r\n";
                }
            $result .= "  </ul></li>\r\n";
            }
        $result .= "</ul></li>\r\n";
        }
    echo $result;

I'm sorry to be a pain, but can you see what I'm doing wrong? Thanks again.

DaniWeb Home > Forums > Web Development > PHP > Report...

Re: Report w/Cateories/subcategories

Report w/Cateories/subcategories

Re: Report w/Cateories/subcategories