<?php include 'config.php'; $query = mysql_query(" SELECT * FROM categories WHERE parent='0' "); $menu .= '<ul>'; while ($c = mysql_fetch_array($query)){ $menu .= '<li><h3>'. $c['category_title'].'</h3>'; $q = mysql_query("SELECT category_title FROM categories WHERE parent = '".$c['category_id']."'"); $menu .= '<ul>'; while ($c2 = mysql_fetch_array($q)){ $menu .= '<li>'. $c2['category_title'].'</li>'; } $menu .= '</ul>'; $menu .= '</li>'; } $menu .= '</ul>'; echo $menu; ?>
<?php $HOST = "localhost"; $USER = "root"; $PASS = ""; $DB = "ВАША БД"; if(!mysql_connect("$HOST", "$USER", "$PASS")) exit(mysql_error()); else {echo "";} if (!mysql_select_db($DB)) exit(mysql_error()); else{echo "";} mysql_query('SET NAMES utf8;'); ?>