1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| $query = "SELECT cat_id, cat_name, cat_father_id FROM category WHERE cat_father_id = '' ORDER BY cat_id DESC";
$categoryArray = $db->select($query);
for ($i=0; $i<count($categoryArray); $i++){
echo $categoryArray[$i]['cat_name'];
echo "<br>";
$query2 = "SELECT cat_id, cat_name, cat_father_id FROM category WHERE cat_father_id = ".$categoryArray[$i]['cat_id']." ORDER BY cat_id ASC";
$subCategoryArray = $db->select($query2);
if (!empty($subCategoryArray)) {
for ($j=0; $j<count($subCategoryArray); $j++){
echo "--->".$subCategoryArray[$j]['cat_name'];
echo "<br>";
}
}
} |
Partager