Help on displaying data in colunm PHP MySQL Modified Preorder Tree Trasversal

Questions

http://img842.imageshack.us/img842/7732/res.png http://img842.imageshack.us/img842/7732/res.png

 $stmt = $conn->prepare("SELECT  node.idCat_ad ,node.".$cat_name.",(COUNT(parent.".$cat_name.") - 1) AS depth 
                       FROM cat_ad AS node 
                       CROSS JOIN cat_ad AS parent 
                       WHERE node.left_node BETWEEN parent.left_node AND parent.right_node
                       GROUP BY node.idCat_ad
                       ORDER BY node.left_node"); 

$stmt->execute();
$treeArray = $stmt->fetchAll();
?>

<div class="column_in_categories">
<div class="menucategories"><ul>

<?php
$x = 0; //counter
$num_cols = 3; //3 colums
$num_rows = count($resTree); //num columns

$result =   ; 

$newArray =array_slice($resTree,1); //removing the root tree

foreach ($newArray as $currNode) { 

   if ($currNode[ depth ] ==1) { //no links in root

     $result .=  <li class="header  .$classSprites. ">  . $currNode[$cat_name] .  </li> ;

  } else{ //if child, we put a link

#
#
  }

 $x++; // incrementing da counter

 if ($x == ceil($num_rows / $num_cols)) { //if a colunm, we clause it and begin another

   $result .=  </ul></div> <div class="menucategories"><ul><li style="display:none;">&nbsp;</li> ;
   $x=0; //
  }

} 
$result .="</ul></div>";
print $result;

https://docs.google.com/document/edit?id=1TEEJaflFmAQZ9Hb7iCt180oW2ZlrLH9frkTxzc8Wtro&hl=en&authkey=CKavtZAP https://docs.google.com/document/edit?id=1TEEJaflFmAQZ9Hb7iCt180oW2ZlrLH9frkTxzc8Wtro&hl=en&authkey=CKavtZAP

Answers

replace

foreach ($newArray as $currNode) { 

   if ($currNode[ depth ] ==1) { //no links in root

     $result .=  <li class="header  .$classSprites. ">  . $currNode[$cat_name] .  </li> ;

  } else{ //if child, we put a link

#
#
  }

 $x++; // incrementing da counter

 if ($x == ceil($num_rows / $num_cols)) { //if a colunm, we clause it and begin another

   $result .=  </ul></div> <div class="menucategories"><ul><li style="display:none;">&nbsp;</li> ;
   $x=0; //
  }

} 

by

foreach ($newArray as $currNode) { 

 $x++; // incrementing da counter

 if ($x >= ceil($num_rows / $num_cols) and $currNode[ depth ] ==1) { //if a colunm, we clause it and begin another

   $result .=  </ul></div> <div class="menucategories"><ul><li style="display:none;">&nbsp;</li> ;
   $x=0; //
  }

   if ($currNode[ depth ] ==1) { //no links in root

     $result .=  <li class="header  .$classSprites. ">  . $currNode[$cat_name] .  </li> ;

  } else{ //if child, we put a link

#
#
  }

} 

This will start new columns only when new headlines start.

Source

License : cc by-sa 3.0

http://stackoverflow.com/questions/3323626/help-on-displaying-data-in-colunm-php-mysql-modified-preorder-tree-trasversal

Related