Форум программистов [Powered by Invision Power Board]

Код
 <?php

         include("db_connect.php");
         
         $resut_array = Array();
         $sub_result_array = Array();
         
         $main_count = 0;
         $sub_count = 0;         
        
         function getInformation($lang)
         {
             global $result_array;
             global $main_count;
             
             $_query ="Select * From `main_menu_table` Where `langua` = '$lang' Order By `order`";
             $result = mysql_query($_query) or die("Statement isn't complited");
             
             $main_count = mysql_num_rows($result);
             echo"$main_count -";
             while ($record = mysql_fetch_array($result))
               {   $result_array[] = $record;   }
         }
         
         function sub_getInformation($lang, $categ)
         {
             global $sub_result_array;
             global $sub_count;
             
             $_query ="Select * From `sub_menu_table` Where `langua` = '$lang' && `category` = '$categ' Order By `order`";
             $result = mysql_query($_query) or die("Statement isn't complited");
             
             $sub_count = mysql_num_rows($result);
             
             while ($record = mysql_fetch_array($result))
               {   $sub_result_array[] = $record;   }
         }
          
         function print_menu($lang)
         {
             global $result_array;
             global $sub_result_array;
             
             global $main_count;
             global $sub_count;
             
             getInformation($lang);
             echo"$main_count <ul>";
             for($i = 0; i < $main_count; $i++)
             {
                 $row = $result_array[$i];
                 $capture = $row["text"];
                 $categ = $row["category"];
                 
                 sub_getInformation($lang, $categ);
                 
                 if($sub_count == 0)
                 {
                     echo"<il><a>$capture</a></il><br />";
                 }
                 else if($sub_count != 0)
                 {
                     echo"<il><a>$capture</a><ul>";
                     for($j = 0; $j < $sub_count; $j++)
                     {
                         $_row = $sub_result_array[$j];
                         $_capture = $_row["text"];

                         echo"<il><a>$capture</a></il><br />";
                     }
                     echo"</ul></il>";
                 }
             }
             echo"</ul>";
         }
     ?>