rk9 site Code

<?php
echo "<div > ";
  
  $lmitems = mysql_query("select * from leftmenu order by morder");		
  $lmitemcount = mysql_num_rows($lmitems);

  
  
  $k=0;//Находим максимальное число пунктов подменю
  for($i=0;$i<$lmitemcount;$i++) 
	if(mysql_result($lmitems,$i,5) <=$permis){
		
		$lmsitemsstr = "select * from leftsubmenu where parent=".mysql_result($lmitems,$i,0)." order by morder";
		$lmsitems = mysql_query($lmsitemsstr);		
		$lmsitemcount = mysql_num_rows($lmsitems);
		if($k<$lmsitemcount) $k = $lmsitemcount;
  }
  
  
  for($i=0;$i<$lmitemcount;$i++) if(mysql_result($lmitems,$i,5) <=$permis){
		
 		$toptable[0][$i*2]="<td><img src=\"".$design_path.mysql_result($lmitems,$i,4)." \"></td>\n";//Взять картинку иконки левого меню
		$toptable[0][$i*2+1]="<td class=\"left_menu\">".mysql_result($lmitems,$i,1)."</td>\n";//Взять название пункта левого меню
		
		$lmsitemsstr = "select * from leftsubmenu where parent=".mysql_result($lmitems,$i,0)." order by morder";//Находим пункты каждого подменю
		$lmsitems = mysql_query($lmsitemsstr);		
		
		for($j=0;$j<$k;$j++) {
			if(mysql_result($lmsitems,$j,3)<=$permis) {
				$toptable[$j+1][$i*2]="<td>&nbsp;</td>\n";
				
				//if( mysql_result($lmsitems,$j,5)!="" ) ;//	echo"<td><p class=\"left_menu_item\"><a href=\"".mysql_result($lmsitems,$j,5)."\" class=\"left_menu_item\" target=\"blanc\"></a></p></td>\n";
				//else echo "<td><p class=\"left_menu_item\"><a href=\"?lsm=".mysql_result($lmsitems,$j,0)."\" class=\"left_menu_item\"></a></p></td>\n";
				if(mysql_result($lmsitems,$j,1)!="") {
					if( mysql_result($lmsitems,$j,5)!="" ) $toptable[$j+1][$i*2+1] =$toptable[$j+1][$i*2+1]."<td><p class=\"left_menu_item\"><a href=\"".mysql_result($lmsitems,$j,5)."\" class=\"left_menu_item\" target=\"blanc\">".mysql_result($lmsitems,$j,1)."</a></p></td>\n";
					else $toptable[$j+1][$i*2+1] =$toptable[$j+1][$i*2+1]."<td><p class=\"left_menu_item\"><a href=\"?lsm=".mysql_result($lmsitems,$j,0)."\" class=\"left_menu_item\">".mysql_result($lmsitems,$j,1)."</a></p></td>\n";
				}
				else $toptable[$j+1][$i*2+1]="<td>&nbsp;</td>\n";				
			}
			else {
				$toptable[$j+1][$i*2]="<td>&nbsp;</td>\n";
				$toptable[$j+1][$i*2+1]="<td>&nbsp;</td>\n";		
				
			}
		}
  }
  
  //Вывод короткого меню
  
  echo "<table width=\"100%\"  cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n";
   for($i=0;$i<$k+1;$i++) {
	echo "	<tr>\n";	  
	  for($j=0;$j<$lmitemcount*2;$j++) {
		  echo $toptable[$i][$j]; 
	  }
	  echo "	</tr>\n";	
  }
  echo "</table>";
  echo "</div>";
  echo "<br>";
  //Вывод новостей и объявлений
  echo "<br><br > ";
  echo "<div > ";
  echo "<table width=\"80%\" align=\"center\" cellpadding=\"0\" cellspacing=\"5\" border=\"0\">\n";
  echo "<tr>\n";
  echo "	<td class=\"news_top_text\" width=\"50%\">\n"; 
  echo "<a class=\"news_top\" href=\"/?mm=4&sm=18\" >Объявления</a>";
  
  echo "	</td>\n";
  echo "	<td class=\"news_top_text\">\n";
  echo "<a class=\"news_top\" href=\"/?mm=4&sm=17\" >Последние новости</a>\n";
  echo "	</td>\n";
  echo "</tr>\n";
  
  echo "<tr>\n";
  //Содержание объявлений
  
  echo "	<td valign=\"top\">\n" ;
  $messagesitems = mysql_query("select * from messages where >\"1\" and permis<=$permis order by messagesdate DESC");		
  $messagesitemcount = mysql_num_rows($messagesitems );

  for($i=0;$i<$messagesitemcount;$i++)  {
	echo "<b>".MStrToDate(mysql_result($messagesitems ,$i,1))." : ".mysql_result($messagesitems ,$i,2)."</b><br>".mysql_result($messagesitems ,$i,3)."<br>";
	echo "<a href=\"/?mm=4&sm=18&messagesid=".mysql_result($messagesitems ,$i,0)."\">Подробнее...</a>";
	echo "<hr>";
  }
  echo "	</td>\n";
  echo "	<td valign=\"top\">\n";
  //Содержание новостей
  $newsitems = mysql_query("select * from news where >\"1\" and permis<=$permis order by newsdate DESC");		
  $newsitemcount = mysql_num_rows($newsitems );

  for($i=0;$i<$newsitemcount;$i++)  {
	echo "<b>".MStrToDate(mysql_result($newsitems ,$i,1))." : ".mysql_result($newsitems ,$i,2)."</b><br>".mysql_result($newsitems ,$i,3)."<br>";
	echo "<a href=\"/?mm=4&sm=17&newsid=".mysql_result($newsitems ,$i,0)."\">Подробнее...</a>";
	echo "<hr>";
  }
  echo "	</td>\n";
  
  echo "</tr>\n";
 
  echo "</table>";
  
echo "</div>";
?>