 |
'')
$result = mysql_query("select ".$table_news.".*, ProbegYear.NameP from ".$table_news.", ProbegYear
where ".$table_news.".Probeg_Year_id=ProbegYear.id and (DATE_FORMAT(news_date, '%Y') = '$currentyear') and (".$table_news.".obl = '$obl') AND ".$table_news.".dj_is_for_social=0
union select *,NULL from ".$table_news."
where Probeg_Year_id is NULL and ".$table_news.".obl = '$obl' and (DATE_FORMAT(news_date, '%Y') = '$currentyear') AND ".$table_news.".dj_is_for_social=0 order by DATE_FORMAT(news_date, '%m') desc, DATE_FORMAT(news_date, '%d') desc, 'news_time' desc",$connect);
if ($fedokrug <>'')
$result = mysql_query("select ".$table_news.".*, ProbegYear.NameP from ".$table_news.", ProbegYear
where ".$table_news.".Probeg_Year_id=ProbegYear.id and (DATE_FORMAT(news_date, '%Y') = '$currentyear') and (".$table_news.".fedokrug = '$fedokrug') AND ".$table_news.".dj_is_for_social=0
union select *,NULL from ".$table_news."
where Probeg_Year_id is NULL and ".$table_news.".fedokrug = '$fedokrug' and (DATE_FORMAT(news_date, '%Y') = '$currentyear') AND ".$table_news.".dj_is_for_social=0 order by DATE_FORMAT(news_date, '%m') desc, DATE_FORMAT(news_date, '%d') desc, 'news_time' desc",$connect);
if ($country <>'')
{if ($country ='abroad')
$result = mysql_query("select ".$table_news.".*, ProbegYear.NameP from ".$table_news.", ProbegYear
where ".$table_news.".Probeg_Year_id=ProbegYear.id and (DATE_FORMAT(news_date, '%Y') = '$currentyear') and (".$table_news.".country <> 'Россия') AND ".$table_news.".dj_is_for_social=0
union select *,NULL from ".$table_news."
where Probeg_Year_id is NULL and ".$table_news.".country <> 'Россия' and (DATE_FORMAT(news_date, '%Y') = '$currentyear') AND ".$table_news.".dj_is_for_social=0 order by DATE_FORMAT(news_date, '%m') desc, DATE_FORMAT(news_date, '%d') desc, 'news_time' desc",$connect);
}
$num_rows = mysql_num_rows($result);
if($num_rows =="0"){print "Нет новостей за этот год!";}?>
"."Архив новостей ".$currentyear. " год"."";?>\n\n";
print " |
