&lt;?
	$sql = sprintf(&quot;SELECT * FROM %s WHERE m_id = %d&quot;, $tbl_main,$m_id);
	$query=mysql_query($sql,$db_conn); 
	$row_s=mysql_fetch_assoc($query); 
?&gt;
&lt;!DOCTYPE HTML PUBLIC &quot;-//W3C//DTD HTML 4.01 Transitional//EN&quot;&gt;

&lt;html&gt;
&lt;head&gt;
	&lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=windows-1251&quot;&gt;
	&lt;meta name=&quot;description&quot; content=&quot;&lt;!--#include virtual=&quot;/inc/navigation/description.html&quot;--&gt;&quot;&gt;
	&lt;meta name=&quot;ROBOTS&quot; content=&quot;all&quot;&gt;
	&lt;link href=&quot;/&quot; rel=&quot;home&quot;&gt;
	&lt;link rel=&quot;alternate&quot; type=&quot;application/rss+xml&quot; title=&quot;RSS&quot; href=&quot;http://www.sotovik.ru/news.xml&quot;&gt;
	&lt;link rel=&quot;SHORTCUT ICON&quot; href=&quot;http://www.sotovik.ru/favicon.ico&quot;&gt;
	&lt;title&gt;&lt;?=$row_s[&quot;m_link5&quot;]?&gt; - Сотовик&lt;/title&gt;
	&lt;style type=&quot;text/css&quot;&gt;
		@import url(/styles/10827_main.css);
	&lt;/style&gt;
&lt;/head&gt;

&lt;body&gt;
&lt;div align=&quot;center&quot;&gt;
	&lt;!-- Header --&gt;
    &lt;!--#include virtual=&quot;/inc/navigation/header.html&quot;--&gt;
    &lt;!-- Header --&gt;
	&lt;div id=&quot;main&quot;&gt;
		&lt;div class=&quot;left_zone&quot;&gt;
			&lt;!-- Banner zone 2 --&gt;
			&lt;!--#include virtual=&quot;/inc/banner_zone/expo_2.html&quot;--&gt;
			&lt;!-- Banner zone 2 --&gt;
			&lt;!-- Banner zone 2-2 --&gt;
			&lt;!--#include virtual=&quot;/inc/banner_zone/expo_2-2.html&quot;--&gt;
			&lt;!-- Banner zone 2-2 --&gt;
			&lt;div class=&quot;menu&quot;&gt;
			&lt;!-- Left menu --&gt;
  			&lt;!--#include virtual=&quot;/inc/lib/left_menu.html&quot;--&gt;
   			&lt;!-- Left menu --&gt;
			&lt;/div&gt;
			&lt;!-- Banner zone 2-3 --&gt;
			&lt;!--#include virtual=&quot;/inc/banner_zone/expo_2-3.html&quot;--&gt;
			&lt;!-- Banner zone 2-3 --&gt;
			&lt;!-- Banner zone 2-4 --&gt;
			&lt;!--#include virtual=&quot;/inc/banner_zone/expo_2-4.html&quot;--&gt;
			&lt;!-- Banner zone 2-4 --&gt;
		&lt;/div&gt;
		&lt;div class=&quot;main_zone&quot;&gt;
			&lt;!-- Banner zone 3 --&gt;
 			&lt;!--#include virtual=&quot;/inc/banner_zone/expo_3.html&quot;--&gt;
			&lt;!-- Banner zone 3 --&gt;
			&lt;h1&gt;&lt;?=$row_s[&quot;m_link5&quot;]?&gt;&lt;/h1&gt;
			&lt;div class=&quot;center_zone&quot;&gt;
				&lt;!-- Выставки --&gt;
 				&lt;!--#include virtual=&quot;/inc/expo/expo.html&quot;--&gt;
				&lt;!-- Выставки --&gt;
				&lt;!-- br&gt;
				&lt;div&gt;
					&lt;p&gt;Архив по годам: 
					&lt;?
					$year = array();
					
					$sql = sprintf(&quot;SELECT * FROM %s WHERE m_parent_id = %d AND m_status = 3 ORDER BY m_name ASC&quot;, $tbl_main,$m_id);
					$query=mysql_query($sql,$db_conn); 
					while ($row_year=mysql_fetch_assoc($query)) {
						if (date('Y') == $row_year[&quot;m_name&quot;])
							$year[] = sprintf(&quot;&lt;strong&gt;%s&lt;/strong&gt;&quot;, $row_year[&quot;m_name&quot;]);
						else
							$year[] = sprintf(&quot;&lt;a href=\&quot;/%s/\&quot;&gt;%s&lt;/a&gt;&quot;, $row_year[&quot;m_path&quot;],$row_year[&quot;m_name&quot;]);
					}
					mysql_free_result($query);
					
					echo join(&quot; | &quot;,$year);
					?&gt;
					&lt;/p&gt;
					&lt;p&gt;
					По месяцам:
					&lt;?
					$month = array();
					$sql = sprintf(&quot;SELECT b.* FROM %s AS a JOIN %s AS b ON (a.m_id = b.m_parent_id) WHERE a.m_parent_id = %d AND a.m_code = '%s' ORDER BY b.m_sort ASC&quot;, $tbl_main,$tbl_main,$m_id,date('Y'));
					$query=mysql_query($sql,$db_conn); 
					while ($row_month=mysql_fetch_assoc($query)) {
						$sql = sprintf(&quot;SELECT COUNT(*) AS count FROM %s WHERE m_parent_id = %d&quot;, $tbl_main,$row_month[&quot;m_id&quot;]);
						$query_expo=mysql_query($sql,$db_conn); 
						$expo=mysql_fetch_assoc($query_expo); 
						
						if (date('m') == $row_month[&quot;m_code&quot;])
							$month[] = sprintf(&quot;&lt;strong&gt;%s&lt;/strong&gt;&quot;, $row_month[&quot;m_name&quot;]);
						elseif ($expo[&quot;count&quot;] &gt; 0)
							$month[] = sprintf(&quot;&lt;a href=\&quot;/%s/\&quot;&gt;%s&lt;/a&gt;&quot;, $row_month[&quot;m_path&quot;],$row_month[&quot;m_name&quot;]);
						else
							$month[] = sprintf(&quot;%s&quot;, $row_month[&quot;m_name&quot;]);
					}
					mysql_free_result($query);
					
					echo join(&quot; | &quot;,$month);
					?&gt;
					&lt;/p&gt;
					&lt;br&gt;
				&lt;/div&gt;
				&lt;?
				$banner = &quot;&quot;;
				$rez=new xml();
				$sql = sprintf(&quot;SELECT c.*,DATE_FORMAT(c.m_link8,'%%d.%%m.%%Y') AS date_public FROM %s AS a JOIN %s AS b ON (a.m_id = b.m_parent_id) JOIN %s AS c ON (b.m_id = c.m_parent_id) WHERE a.m_parent_id = %d AND a.m_code = '%s' ORDER BY c.m_link8 ASC&quot;, $tbl_main,$tbl_main,$tbl_main,$m_id,date('Y'));
				$query=mysql_query($sql,$db_conn); 
				while ($row_expo=mysql_fetch_assoc($query)) {
					$banner = &quot;&quot;;
					$sql = sprintf(&quot;SELECT * FROM %s WHERE m_parent_id = %d AND m_code = 'banner'&quot;, $tbl_main,$row_expo[&quot;m_id&quot;]);
					$queryImages=mysql_query($sql,$db_conn);
					$rowsImages=mysql_fetch_assoc($queryImages);
				
					$rez-&gt;xml=$row_expo['m_main_content'];
					$rez-&gt;get();
					
					if ($row_expo[&quot;m_link2&quot;]) {
						$rez-&gt;Name = sprintf(&quot;&lt;a href=\&quot;http://sotovik.ru/lib/2operator/expo/%s\&quot;&gt;%s&lt;/a&gt;&quot;, $row_expo[&quot;m_link2&quot;],$rez-&gt;Name);
					}
					if (is_array($rowsImages)) {
						$banner = sprintf(&quot;&lt;p&gt;&lt;center&gt;&lt;a href=\&quot;%s\&quot; target=\&quot;_blank\&quot;&gt;&lt;img src=\&quot;http://www.sotovik.ru/%s/%s\&quot; border=\&quot;0\&quot;&gt;&lt;/a&gt;&lt;/center&gt;&lt;/p&gt;&quot;, $rowsImages[&quot;m_url&quot;],$rowsImages[&quot;m_path&quot;],$rowsImages[&quot;m_file&quot;]);
					}
					printf(&quot;&lt;div class=\&quot;expo\&quot;&gt;&lt;h2&gt;%s&lt;/h2&gt;&lt;p&gt;&lt;b&gt;Дата проведения:&lt;/b&gt; %s - %s&lt;/p&gt;&lt;p&gt;&lt;b&gt;Место проведения:&lt;/b&gt; %s&lt;/p&gt;&lt;p&gt;%s&lt;/p&gt;%s%s%s%s%s%s&lt;/div&gt;&quot;, $rez-&gt;Name,$row_expo[&quot;date_public&quot;],$rez-&gt;DateTo_day,$rez-&gt;Place,$rez-&gt;Info,($rez-&gt;Organizator ? &quot;&lt;p&gt;&lt;b&gt;Организатор выставки:&lt;/b&gt; &quot;.$rez-&gt;Organizator.&quot;&lt;/p&gt;&quot; : &quot;&quot;),($rez-&gt;Phone ? &quot;&lt;p&gt;&lt;b&gt;Телефон:&lt;/b&gt; &quot;.$rez-&gt;Phone.&quot;&lt;/p&gt;&quot; : &quot;&quot;),($rez-&gt;Fax ? &quot;&lt;p&gt;&lt;b&gt;Факс:&lt;/b&gt; &quot;.$rez-&gt;Fax.&quot;&lt;/p&gt;&quot; : &quot;&quot;),($rez-&gt;Email ? &quot;&lt;p&gt;&lt;b&gt;E-mail:&lt;/b&gt; &lt;a href=\&quot;mailto:&quot;.$rez-&gt;Email.&quot;\&quot;&gt;&quot;.$rez-&gt;Email.&quot;&lt;/a&gt;&lt;/p&gt;&quot; : &quot;&quot;),($rez-&gt;Site ? &quot;&lt;p&gt;&lt;b&gt;Название сайта:&lt;/b&gt; &lt;a href=\&quot;&quot;.$rez-&gt;Site.&quot;\&quot; target=\&quot;_blank\&quot;&gt;&quot;.$rez-&gt;Site.&quot;&lt;/a&gt;&lt;/p&gt;&quot; : &quot;&quot;),$banner);
				}
				mysql_free_result($query);
				?&gt;
				--&gt;
			&lt;/div&gt;
			&lt;div class=&quot;right_zone&quot;&gt;
				&lt;!-- Banner zone 4 --&gt;
 			    &lt;!--#include virtual=&quot;/inc/banner_zone/4.html&quot;--&gt;
				&lt;!-- Banner zone 4 --&gt;
				
				&lt;!-- Banner zone 5 --&gt;
 			    &lt;!--#include virtual=&quot;/inc/banner_zone/expo_5.html&quot;--&gt;
				&lt;!-- Banner zone 5 --&gt;
			&lt;/div&gt;
		&lt;/div&gt;
	&lt;/div&gt;
	&lt;!-- Footer --&gt;
    &lt;!--#include virtual=&quot;/inc/navigation/footer.html&quot;--&gt;
    &lt;!-- Footer --&gt;
&lt;/div&gt;

&lt;/body&gt;
&lt;/html&gt;