Файл: vkolhoze.com/inc/oxota/top.php
Строк: 26
<?
require_header ('Лучшие охотники');
$k_post=mysql_result(mysql_query("SELECT COUNT(*) `ids` FROM `oxota` WHERE `zvereu_ubito` > '0'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
if ($k_post==0)
{
echo"<div class='content'>";
echo " <div class='block'>n";
echo "Нет результатовn";
echo " </div>n";
}
$q=mysql_query("SELECT `ids` FROM `oxota` WHERE `zvereu_ubito` > '0' ORDER BY `zvereu_ubito` DESC LIMIT $start, $set[p_str]");
while ($post = mysql_fetch_assoc($q))
{
$ank=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_user` WHERE `id` = '$post[ids]' LIMIT 1"));
echo " <div class='block'>n";
echo "".on_k($ank['id'])."<a href='?user=$ank[id]'>$ank[nick]</a>n";
$arr=mysql_fetch_array(mysql_query("SELECT * FROM `oxota` WHERE `ids`='$ank[id]' LIMIT 1"));
echo "Убил: <b>".$arr['zvereu_ubito']."</b> зверей.<br/>";
echo " </div>n";
}
echo "<div class='block'>"; if ($k_page>1)str("?ohota_top&",$k_page,$page);
echo "<br><a class='loc' href='?ohota_index'><img src='http://icons.iconarchive.com/icons/icojam/onebit/24/arrow-left-icon.png'> Назад</a>";
include_once 'inc/foot.php';
?>