Rambler's Top100 Home page Contacts Site map

History
Activities
Young Peacemakers
News
Virtual Excursions
Useful Links
Guest book


Russian version

 
\n\t\t\t

Pages: "); if($page != 1) { $previous = $page - 1; print("[<<]  "); } for ($i = 1; $i <= $pages; $i++){ if($i == $page) { print("$i"); } else { print("$i"); } if($i != $pages) { print(" | "); } } if($page != $pages) { $next = $page + 1; print(" | Next >>"); } } if(!($connection = @mysql_connect($db_host, $db_user, $db_passwd))) { print("Could not connect to MySQL!"); } else { mysql_set_charset('cp1251', $connection); if(!(@mysql_select_db($db_name, $connection))) { print("Could not select database!"); } else { // Подсчёт количества страниц $all_news_query = @mysql_query("SELECT * FROM news WHERE body_eng <> '';"); $all_news = @mysql_num_rows($all_news_query); $pages = (int) ($all_news / $number) + 1; // Вывод результатов // Запрашиваем новости с датой, переведённой в формат UNIX $result = mysql_query("SELECT UNIX_TIMESTAMP(date), subject_eng, body_eng FROM news WHERE body_eng <> '' ORDER BY date DESC LIMIT $start, $number;"); @mysql_close($connection); while(($news = mysql_fetch_array($result))) { printf("\t\t\t

\n\t\t\t
[%s]
\n", date("d F, Y", $news[0])); if($news['subject_eng']) { print("\t\t\t
{$news['subject_eng']}
\n"); } printf("\t\t\t
%s
\n\t\t\t
\n", $news['body_eng']); } list_pages(); } } ?>
Rambler's Top100
Home page Contacts Site map On top