if(empty($article))
{
if(empty($page))
{
$result = mysql_query("SELECT * FROM `blog` WHERE id > 0 ORDER BY `blog`.`date` DESC LIMIT $old_count_page, 5");
$res_count = mysql_query("SELECT COUNT(*) as count FROM `blog` WHERE id > 0 ORDER BY `blog`.`date` DESC");
$rowcount = mysql_fetch_row($res_count);
$countnewproduct = $rowcount[0];
$col_page = $countnewproduct/5;
$col_page = ceil($col_page);
}
else
{
$result = mysql_query("SELECT * FROM `blog` WHERE id > 0 ORDER BY `blog`.`date` DESC LIMIT $old_count_page, 5");
$res_count = mysql_query("SELECT COUNT(*) as count FROM `blog` WHERE id > 0 ORDER BY `blog`.`date` DESC");
$rowcount = mysql_fetch_row($res_count);
$countnewproduct = $rowcount[0];
$col_page = $countnewproduct/5;
$col_page = ceil($col_page);
}
if(mysql_num_rows($result) > 0)
{
while($row = mysql_fetch_array($result))
{
$url_article = $row['url'];
$name_article = $row['name'];
$name_article = iconv("cp1251", "utf-8", $name_article);
$text_article = $row['text'];
$text_article = iconv("cp1251", "utf-8", $text_article);
$photo_article = $row['photo'];
$date_article = $row['date'];
$Month_r = array(
"01" => "января",
"02" => "февраля",
"03" => "марта",
"04" => "апреля",
"05" => "мая",
"06" => "июня",
"07" => "июля",
"08" => "августа",
"09" => "сентября",
"10" => "октября",
"11" => "ноября",
"12" => "декабря");
$now_month = date("m", $date_article);
$day = date("j", $date_article);
$month = $Month_r[$now_month];
$year = date("Y", $date_article);
?>
}
?>
$page_product_pred = $page_product-1;
for ($i = 1; $i <= $col_page; $i++)
{
if($i == $page_product)
{
$classpage = "page-numbers current";
}
else
{
$classpage = "page-numbers";
}
echo "
$i";
}
$page_product_next = $page_product+1;
?>
}
else
{
?>
}
}
else
{
$result_full = mysql_query("SELECT * FROM `blog` WHERE url = '$article'");
if(mysql_num_rows($result_full) > 0)
{
$row = mysql_fetch_array($result_full);
$url_article = $row['url'];
$name_article = $row['name'];
$name_article = iconv("cp1251", "utf-8", $name_article);
$text_article = $row['full_text'];
$text_article = iconv("cp1251", "utf-8", $text_article);
$photo_article = $row['photo'];
$date_article = $row['date'];
$Month_r = array(
"01" => "января",
"02" => "февраля",
"03" => "марта",
"04" => "апреля",
"05" => "мая",
"06" => "июня",
"07" => "июля",
"08" => "августа",
"09" => "сентября",
"10" => "октября",
"11" => "ноября",
"12" => "декабря");
$now_month = date("m", $date_article);
$day = date("j", $date_article);
$month = $Month_r[$now_month];
$year = date("Y", $date_article);
?>
}
}
?>