PHP showing menu tree in dropdown list

Question

Function for the menu tree:

function category_tree($parent_id)
{
    $sql = "SELECT * FROM menu WHERE parent_id ='".$parent_id."'";
    $result = $conn->query($sql);

    echo "<div id=\"wrapper\">
    <div id=\"navmenu\">";
    while($row = mysqli_fetch_object($result)):
        $i = 0;
        if ($i == 0) echo '<ul>';
        echo '<li>' . $row->name;
        category_tree($row->id);
        echo '</li>';
        $i++;
        if ($i > 0) echo '</ul>';
    endwhile;
    echo "</div>
    </div>";
}

CSS file:

#navmenu {
    margin: 0;
    padding: 0;
}

#navmenu ul{
    margin: 0;
    padding: 0;
    height:30px;
}

#navmenu li{
    margin: 0;
    padding: 0;
    list-style: none;
    float: left;
    position: relative;
    background:#09F;

}

#navmenu ul li a{
    text-align:center;
    text-decoration:none;
    font-family:Arial, Helvetica, sans-serif;
    height:30px;
    width:150px;
    display:block;
    color:#000066;
    padding-top:7px;
}

#navmenu ul ul{
    position:absolute;
    visibility: hidden;
    top:30px;
}

#navmenu ul li:hover ul {
    visibility:visible;
}

#navmenu li:hover {
    background:#3366CC;
}

#navmenu ul li:hover ul li a:hover{
    background:#03C;
    color:#FFFFFF;
}

Database for recursive menu:

The result without using the div element (id = wrapper, id = navmenu) works well, see

When I return div elements (id = wrapper, id = navmenu), it doesn't happen what I want:

I want: when my cursor on the "Felso" menu displays a drop-down menu (Sport, Ekszer, Egyeb), and if my cursor on "Foci" shows a drop-down menu (Mezek, Egyeb, Utok, Labdak), etc ... Any ideas how I can do this, or how to fix my code?

Answer 1

Ok I moved this problem, here is my code:

function get_menu_tree($parent_id)
{
    global $conn;
    $menu = "";
    $sqlquery = " SELECT * FROM menu where parent_id='" .$parent_id . "' ";
    $res=mysqli_query($conn,$sqlquery);
    while($row=mysqli_fetch_array($res,MYSQLI_ASSOC))
    {
        $menu .="<li><a href='".$row['link']."'>".$row['name']."</a>";

        $menu .= "<ul>".get_menu_tree($row['id'])."</ul>"; //call  recursively

        $menu .= "</li>";

    }
    return $menu;
}