Dynamic Drop Down Menu and submenu php mysql

Question

I have a menu that needs to be created dynamically from the database. need to have menu and submenu

for example (wht i want):

<ul class="dropdown">
    <li><a href="#">Link 1</a> </li>
    <li><a href="#">Link 2</a> </li>
    <li><a href="#">Link 3</a> </li>
    <li><a href="#">Link 4</a>
    <ul class="sub_menu">
        <li><a href="#">Link 4 - 1</a></li>
        <li><a href="#">Link 4 - 2</a></li>
        <li><a href="#">Link 4 - 3</a></li>
    </ul>
    </li>
    <li><a href="#">Link 5</a></li>
    <li><a href="#">Link 6</a> </li>
</ul>

below is the code i used for menu using function i want submenu as well

function listMenu(){
    $ans = $this->select("cat_id,cat_name","s_category","1");
    if(is_array($ans)){
        foreach($ans as $val){
            echo 
            "<li><a href=\"post-summary.php?cid=$val[0]\" >$val[1]</a></li>";
        }
    }
    else{
        echo "";
    }
}

database is as follows:-

CREATE TABLE IF NOT EXISTS `s_category` (
  `cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(15) NOT NULL,
  `cat_uid` int(2) NOT NULL,
  `cat_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cat_parent` int(11) DEFAULT '0',
  `cat_sort` int(11) DEFAULT NULL,
  `cat_delete` int(1) DEFAULT '0',
  PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

Answer 1

as far as menus are concerned storing the submenus as a comma seperated values in the database would come handy.

ie consider a table with id,menus,submenus(several submenus seperated by a comma).

 function listMenu(){
$ans = $this->select("menus,submenus");
if(is_array($ans)){
    foreach($ans as $val){
        echo    "<li><a href=\"post-summary.php?cid=$val[0]\" >$val[0]</a>"; //menus

        $submenu = explode(",",$val[1]);

        foreach($submenu as $values){
        echo    "<li><a href=\"post-summary.php?cid=$val[0]&proname=$values\" >$values</a></li>"; // submenus
        }
        echo "</li>";
    }
 }
}

try this

$con    =   db_connect();
$str    =   "select menus,submenus from your_tabel  ";
$result =   mysql_query($str,$con);

while($arr = mysql_fetch_array($result))
{
    echo    "<li><a href=\"post-summary.php?cid=$arr[0]\" >$arr [0]</a>"; //menus

        $submenu = explode(",",$arr [1]);

//make sure you have several sub-menus else use a if condition here to avoid foreach error  
        foreach($submenu as $values){
        echo    "<li><a href=\"post-summary.php?cid=$arr[0]&proname=$values\" >$values</a></li>"; // submenus
        }
        echo "</li>";
    }

this works fine for me just tested now

comment if working. comment if not-working.