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;"> </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