check_search_string($_GET['path']);} else { $path='index';} if (isset ($_GET['page'])) {$page = (int) $_GET['page'];} else {$page=1;} $my->sql_connect(); $query = "SELECT count(*) FROM artwords"; $result = $my->get_link()->query($query); $row = $result->fetch_array(); $count=$row[0]; if (mysql_error()) { print(mysql_error()); } $result->close(); $pages = ceil($count / $onpage); $offset = ($page - 1) * $onpage; $start = $offset + 1; $end = min(($offset + $onpage), $count); $prevlink = ($page > 1) ? '« ‹' : '« ‹'; $nextlink = ($page < $pages) ? '› »' : '› »'; $listofpages= "

$prevlink Стр $page из $pages, показаны $start - $end из $count $nextlink

"; require_once('/usr/local/www/aphorism.ru/www/ssi/head.shtml'); echo "
$listofpages
\n"; $ii=0; $yy=0; $aSQL = "SELECT b.path AS section,a.path,a.texts,b.nameRus,DATE_FORMAT(a.date_registration, '%d.%m.%Y %h:%m:%s') AS date_pub FROM artwords a JOIN aphorism_section b ON a.id_section=b.id ORDER BY a.date_registration DESC LIMIT $onpage OFFSET $offset"; $result = $my->get_link()->query($aSQL); while($row = $result->fetch_array()){ echo "
".substr(stripslashes($row['texts']),0,50)." [".$row['nameRus']."]
".$row['date_pub']."

\n"; $ii++; if (($ii==$ads) && ($yy < 1)) { require_once('/usr/local/www/aphorism.ru/www/ssi/ads-small.php'); $ii=0; $yy++; } elseif (($ii==$ads) && ($yy > 0)) { require('/usr/local/www/aphorism.ru/www/ssi/ads-small2.php'); $ii=0; $yy++; }; }; echo "
$listofpages
\n"; require_once('/usr/local/www/aphorism.ru/www/ssi/adsense_1.shtml'); require_once('/usr/local/www/aphorism.ru/www/ssi/bottom.shtml'); $my->sql_close(); ?>