{php}

$table="SC_articles";
$num=3; // Количество заголовков статей в столбце
$onpage=3; // Количество анонсов статей на странице
$style_name="font-size:130%; padding:5px;";
$style_head="padding:1px 5px 1px 5px; background-color:#ffffff;";

if(isset($_GET['page']) and $_GET['page']>0){$page=$_GET['page'];}
else {$page=1;}
$rows=mysql_count($table);
$start_row=$page*$onpage-$onpage;


if($_GET['action']=='select'){
$query="SELECT ID,Date,Name,Description_short,Description FROM $table WHERE ID='".$_GET['id']."' ORDER BY ID ASC";
$result = mysql_queryf($query);
$art_arr=all_articles($result);
print "<table><tr><td>";
print "<div style='$style_name'><b>".$art_arr[0]['Name']."</b><div>";
print "<div class='art_desc'>".$art_arr[0]['Description']."<div>";
print "</td></tr></table>";
}

if(!isset($_GET['action'])){
$query="SELECT ID,Date,Name,Description_short,Description FROM $table ORDER BY ID DESC LIMIT $start_row,$onpage";
$result = mysql_queryf($query);
$art_arr=all_articles($result);

print "<table><tr><td>";
foreach ($art_arr as $value){
    $id=$value['ID'];
    $name=$value['Name'];
    $Description_short=$value['Description_short'];
	print "<div class='name' style='$style_head'><a href='/auxpage_articles/?page=$page&action=select&id=$id'><h3>$name</h3></a></div>\n\r";
	print "<div class='art_descs'>$Description_short<div>";
    
}
print "</td></tr></table><br>";

print paginator($rows,$onpage,$page);
}









function mysql_queryf($sql_query){
    return mysql_query($sql_query);
}

function all_articles($result) {
    $i=0;
    while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $rows[$i]=$row;
    $i++;
    }
    mysql_free_result($result);
    return $rows;
}

function mysql_count($table){
    $result = mysql_query("SELECT COUNT(*) FROM $table");
    $rows = mysql_fetch_array($result); 
    mysql_free_result($result);
    return $rows[0];
}

function paginator($num,$onpage,$page){
    $pages = ceil($num/$onpage);
    $str.="<div>";
    for($i=1;$i<=$pages;$i++){
	if($i!=$page){
	$str.="<div style='float:left;'><a href='/auxpage_articles/?page=$i'>$i</a></div>";
	}
	if($i==$page){
	$str.="<div style='float:left;'><b>&nbsp;$i&nbsp;</b></div>";
	}
    }
    $str.="</div>";
    return $str;
}    


{/php}