function display_children($parent, $level) { global $mdb2; // retrieve all children of $parent $query = 'SELECT cat_name,cat_id FROM categories WHERE cat_parent_id="' . $parent . '" ORDER BY cat_pos;'; $subcats =& $mdb2->queryAll($query); if (PEAR::isError($subcats)) { $msg = 'Erreur survenue lors du chargement des preferences :' . $subcats->getMessage(); $this->my_die($msg); } print_r($subcats); if (!empty($subcats)) { foreach ($subcats as $key => $value) { echo 'here'; return str_repeat('    ',$level) . $value['cat_name'] . "
" . display_children($value['cat_id'], $level+1); } } } foreach ($cats as $key => $value) { $content .= $value['cat_name'] . "
" . display_children($value['cat_id'],1); }