include("art_adm/class/phplibs_mysql.php");
BaseConnect();
//error_reporting(E_ALL);
$to_page = 10;
$pages_links = 5;
if(!isset($_GET[page])){$_GET[page]=1;}
$p = ($_GET['page'] * $to_page) - $to_page;
$res_count=mysql_query("SELECT count(*) as qwe FROM art_news");
$count = mysql_result($res_count,0,'qwe');
$pages = ceil($count / $to_page);
if ($_GET['page'] > $pages) {
header("Location: ".$PHP_SELF."?page=".$pages);
} elseif($_GET['page'] < 1) {
header("Location: ".$PHP_SELF."?page=1");
}
$sql="SELECT zagolovok, text, EXTRACT(DAY FROM data) as day, EXTRACT(MONTH FROM data) as month, EXTRACT(YEAR FROM data) as year, id FROM art_news ORDER BY data DESC LIMIT ".$p.", ".$to_page;
$res=mysql_query($sql) or die(mysql_error());
?>
Новости Концертное Агентство Самоцветы Юрия Маликова, ансамбль, ВИА, группа Самоцветы, музыка, праздник
while ($news=mysql_fetch_assoc($res))
{
if (strlen($news['month'])==1){$news['month']="0".$news['month'];}
if (strlen($news['day'])==1){$news['day']="0".$news['day'];}
echo"