include "ban_inc.php";
?>
|
|
|
$qt_page="SELECT * from pam65_imjshiz where id=1 ";
$res_page=mysql_query($qt_page);
print mysql_result($res_page,0,'page_text');
?>
|
|
|
|
|
$qt_news_all="SELECT * from pam65_news where izb_ebrand!=1 order by id DESC LIMIT 0,16 ";
$res_news_all=mysql_query($qt_news_all);
$num_news_all=mysql_num_rows($res_news_all);
$sel2="SELECT count(*) FROM pam65_news ";
$res_sel2=mysql_query($sel2);
$row_sel2=mysql_fetch_row($res_sel2);
$total_rows_sel2=$row_sel2[0];
for($i=0;$i<$num_news_all;$i++)
{
print '
|
'.mysql_result($res_news_all,$i,'zagalovk').'';
print ' |
| '.substr(mysql_result($res_news_all,$i,'data'),6,2).'.'.substr(mysql_result($res_news_all,$i,'data'),4,2).'.'.substr(mysql_result($res_news_all,$i,'data'),2,2);
$sel2_com="SELECT count(*) FROM pam65_news_comments where news_id=".mysql_result($res_news_all,$i,'id');
$res_sel2_com=mysql_query($sel2_com);
$row_sel2_com=mysql_fetch_row($res_sel2_com);
$total_rows_sel2_com=$row_sel2_com[0];
if($total_rows_sel2_com)print ' Comments('.$total_rows_sel2_com.')';
else print ' Comments(0)';
print ' |
|
';
}
?>
|
|
|
|
include "right_inc.php";
//////magazine
$qt_magazine_interview="SELECT * from pam65_magazine_interview order by id DESC limit 0,10 ";
$res_magazine_interview=mysql_query($qt_magazine_interview);
$num_magazine_interview=mysql_num_rows($res_magazine_interview);
if($num_magazine_interview)
{
?>
|
////////
for($i=0;$i<$num_magazine_interview;$i++)
{
print '
|
|
';
}
?>
|
}
//////magazine
$qt_razdel_page="SELECT * from pam65_razdel_page where hastatel=1 and page_text!='' order by id DESC limit 0,7 ";
$res_razdel_page=mysql_query($qt_razdel_page);
$num_razdel_page=mysql_num_rows($res_razdel_page);
if($num_razdel_page)
{
?>
|
|
for($i=0;$i<$num_razdel_page;$i++)
{
$razd_id=mysql_result($res_razdel_page,$i,'parent_id');
$qt_razdel1="SELECT * from pam65_razdel where id='$razd_id' ";
$res_razdel1=mysql_query($qt_razdel1);
$cl_st='';
if($i!=$num_razdel_page-1)
$cl_st='class="botline3"';
$str_brand=strip_tags(substr(mysql_result($res_razdel_page,$i,'page_text'),0,800));
print '
|
|
';
}
?>
|
}
?>
|
$qt_exhibition_firm_video10="SELECT DISTINCT parent_id from pam65_exhibition_firm_video ORDER BY RAND() LIMIT 0, 5 ";
$res_exhibition_firm_video10=mysql_query($qt_exhibition_firm_video10);
$num_exhibition_firm_video10=mysql_num_rows($res_exhibition_firm_video10);
for($i=0;$i<$num_exhibition_firm_video10;$i++)
{
$par_id=mysql_result($res_exhibition_firm_video10,$i,'parent_id');
$qt_exhibition_firm_video1="SELECT * from pam65_exhibition_firm_video where parent_id='$par_id' ";
$res_exhibition_firm_video1=mysql_query($qt_exhibition_firm_video1);
if(mysql_result($res_exhibition_firm_video1,0,'exhibition_firm_video_prev') && file_exists("images/exhibition/video/video_p/".mysql_result($res_exhibition_firm_video1,0,'exhibition_firm_video_prev')))
{
print '';
print ' .') ';
print ' ';
}
print ' ';
}
?>
|
|