select m3.id, m3.g1, m3.g2, m3.g3, m3.g4, m3.g5, m3.g6, m3.g7, m3.g8, m3.block from tb_menu m1, tb_menu m2, tb_menu m3 where m1.id=141 and m1.parent_id=m2.id and m2.parent_id=m3.id and m3.parent_id=0 and m3.block != 1

<?php  
    /*function MenuShow() 
    {
        $query = 'select * 
                from '._TB_MENU_.' order by sorting,id';
        $sql = mysql_query($query) or die(mysql_error());
        
        while ($row=mysql_fetch_array($sql))
        {
            echo $row["name"];    
        }
    } */
    
    function MenuShow($cur_mnu , $control_menue)
    {
        
        
                       if($control_menue==' and g1 != 1'){
                $control_menue=' and m1.g1 != 1 and m2.g1 != 1  and m3.g1 != 1';     
               }else if($control_menue==' and g2 != 1'){
                $control_menue=' and m1.g2 != 1 and m2.g2 != 1  and m3.g2 != 1';
               }else if($control_menue==' and g3 != 1'){
                $control_menue=' and m1.g3 != 1 and m2.g3 != 1  and m3.g3 != 1';
               }else if($control_menue==' and g4 != 1'){
                $control_menue=' and m1.g4 != 1 and m2.g4 != 1  and m3.g4 != 1';  
               }else if($control_menue==' and g5 != 1'){
                $control_menue=' and m1.g5 != 1 and m2.g5 != 1  and m3.g5 != 1';    
               }else if($control_menue==' and g6 != 1'){
                $control_menue=' and m1.g6 != 1 and m2.g6 != 1  and m3.g6 != 1';  
               }else if($control_menue==' and g7 != 1'){
                $control_menue=' and m1.g7 != 1 and m2.g7 != 1  and m3.g7 != 1';  
               }else if($control_menue==' and g8 != 1'){
                $control_menue=' and m1.g8 != 1 and m2.g8 != 1  and m3.g8 != 1';   
               }else if($control_menue==' and block != 1'){
                $control_menue='  and m3.block != 1   ';   
               }
               
        
        
        
        $query = 'select m3.id, m3.g1, m3.g2, m3.g3, m3.g4, m3.g5, m3.g6, m3.g7, m3.g8, m3.block   
                from '._TB_MENU_.' m1, '._TB_MENU_.' m2, '._TB_MENU_.' m3 where m1.id='.$cur_mnu.' and m1.parent_id=m2.id and m2.parent_id=m3.id and m3.parent_id=0 '.$control_menue.'';
               // print_r($query);
               
               
               
               
                     if($control_menue==' and m1.g1 != 1 and m2.g1 != 1  and m3.g1 != 1'){
                $control_menue=' and g1 != 1';    
               }else if($control_menue==' and m1.g2 != 1 and m2.g2 != 1  and m3.g2 != 1'){
                $control_menue=' and g2 != 1';
               }else if($control_menue==' and m1.g3 != 1 and m2.g3 != 1  and m3.g3 != 1'){
                $control_menue=' and g3 != 1'; 
               }else if($control_menue==' and m1.g4 != 1 and m2.g4 != 1  and m3.g4 != 1'){
                $control_menue=' and g4 != 1'; 
               }else if($control_menue==' and m1.g5 != 1 and m2.g5 != 1  and m3.g5 != 1'){
                $control_menue=' and g5 != 1';     
               }else if($control_menue==' and m1.g6 != 1 and m2.g6 != 1  and m3.g6 != 1'){
                $control_menue=' and g6 != 1';  
               }else if($control_menue==' and m1.g7 != 1 and m2.g7 != 1  and m3.g7 != 1'){
                $control_menue=' and g7 != 1';  
               }else if($control_menue==' and m1.g8 != 1 and m2.g8 != 1  and m3.g8 != 1'){
                $control_menue=' and g8 != 1';  
               }else if($control_menue==' and m1.block != 1 and m2.block != 1 and m3.block != 1'){
                $control_menue=' and block != 1';  
               }                
               
               
               
               
               
               
        $sql = mysql_query($query) or die(mysql_error());
        // print_r($sql);
        if(mysql_numrows($sql)>0)
        {
            $row=mysql_fetch_array($sql);
            $cur_main_mnu = $row["id"];    
        }
        else
        {
            $query = 'select m2.id, m2.g1, m2.g2, m2.g3, m2.g4, m2.g5, m2.g6, m2.g7, m2.g8, m2.block 
                    from '._TB_MENU_.' m1, '._TB_MENU_.' m2 where m1.id='.$cur_mnu.' and m1.parent_id=m2.id and m2.parent_id=0';
            $sql = mysql_query($query) or die(mysql_error());   
            if(mysql_numrows($sql)>0)
            {
                $row=mysql_fetch_array($sql);
                $cur_main_mnu = $row["id"];        
            }
            else
            {
                $cur_main_mnu = $cur_mnu;
            }
        }
        
        $query = 'select m1.* 
                from '._TB_MENU_.' m1, '._TB_MENU_.' m2  where m1.parent_id='.$cur_main_mnu.' and m1.id=m2.parent_id and m2.id='.$cur_mnu;
        $sql = mysql_query($query) or die(mysql_error());

        $row=mysql_fetch_array($sql);
        $cur_sub_mnu = $row["id"];

        $query = 'select * 
                from '._TB_MENU_.' where parent_id=0 '.$control_menue.' order by sorting,id';
                                //print_r($query);
        $sql = mysql_query($query) or die(mysql_error());

        echo '<div id="menu-main">';
        echo '<ul class="top-menu">';
        while ($row=mysql_fetch_array($sql))
        {
            echo "<li class='".($cur_main_mnu==$row["id"]?"active":"")."'><a href='/?mnu_id=".$row["id"]."'>".$row["name"]."</a></li>";    
        }    
        echo '</ul>';
        echo '</div>';
        
        $query = 'select * 
                    from '._TB_MENU_.' where parent_id='.$cur_main_mnu.' '.$control_menue.' order by sorting,id';
        $sql = mysql_query($query) or die(mysql_error());     
            
        if($cur_mnu!=0 && mysql_numrows($sql)>0)
        {
            
            /*$query = 'select * 
                    from '._TB_MENU_.' where parent_id='.$cur_main_mnu.' order by sorting,id';
            $sql3 = mysql_query($query) or die(mysql_error());     
            $row = mysql_fetch_array($sql3);*/


            echo '<div id="menu-sub-main">';
            
            echo '<ul class="top-sub-menu">';
            while ($row=mysql_fetch_array($sql))
            {
                echo "<li class='".($cur_mnu==$row["id"]?"active":($cur_sub_mnu==$row["id"]?"active":"!!!"))."'><a href='/?mnu_id=".$row["id"]."'>".$row["name"]."</a>";
                echo "</li>";    
            }    
            echo '</ul></div>';
            
            $query = 'select * 
                        from '._TB_MENU_.' m where parent_id='.$cur_mnu.' '.$control_menue.'
                        and exists(select * from '._TB_MENU_.' where id=m.parent_id && parent_id!=0 '.$control_menue.')
                        order by sorting,id';
            $sql2 = mysql_query($query) or die(mysql_error()); 
            
            $query = 'select m1.parent_id 
                    from '._TB_MENU_.' m1, '._TB_MENU_.' m2 where m1.id='.$cur_mnu.' and m1.parent_id=m2.id and m2.parent_id!=0 order by m1.sorting,m1.id';
            $sql = mysql_query($query) or die(mysql_error());   
            
            if(mysql_numrows($sql2)>0 || mysql_numrows($sql)>0)
            {   
                echo"<div class=\"pause\"><ul class=\"ShowMenu\">";
                if(mysql_numrows($sql2)>0)
                {
                    while($row2=mysql_fetch_array($sql2))
                    {
                        echo "<li class='".($cur_mnu==$row2["id"]?"active":"")."'><a class='".($cur_mnu==$row2["id"]?"active":"")."' href='/?mnu_id=".$row2["id"]."'>".$row2["name"]."</a>";
                    }
                    echo '</ul></div>'; 
                }
                else
                {
                    $row2=mysql_fetch_array($sql);
                    $parent=$row2["parent_id"];
                    $query = 'select m1.*
                    from '._TB_MENU_.' m1, '._TB_MENU_.' m2 where m1.parent_id='.$parent.' and m1.parent_id=m2.id and m2.parent_id!=0 order by m1.sorting,m1.id';
                    $sql = mysql_query($query) or die(mysql_error());
                    
                    while($row2=mysql_fetch_array($sql))
                    {
                        echo "<li class='".($cur_mnu==$row2["id"]?"active":"")."'><a class='".($cur_mnu==$row2["id"]?"active":"")."' href='/?mnu_id=".$row2["id"]."'>".$row2["name"]."</a>";
                    }           
                    echo '</ul></div>';                     
                }
            }                       
                   
        }
    }
    
  
?>

exit($control_menue);

print_r($control_menue);

 $query = 'select m3.id, m3.g1, m3.g2, m3.g3, m3.g4, m3.g5, m3.g6, m3.g7, m3.g8, m3.block   
                from '._TB_MENU_.' m1, '._TB_MENU_.' m2, '._TB_MENU_.' m3 where m1.id='.$cur_mnu.' and m1.parent_id=m2.id and m2.parent_id=m3.id and m3.parent_id=0 '.$control_menue.'';