View file hockey/team.php

<?
include_once '../../sys/inc/start.php';
include_once '../../sys/inc/compress.php';
include_once '../../sys/inc/sess.php';
include_once '../../sys/inc/home.php';
include_once '../../sys/inc/settings.php';
include_once '../../sys/inc/db_connect.php';
include_once '../../sys/inc/ipua.php';
include_once '../../sys/inc/fnc.php';
include_once '../../sys/inc/user.php';
only_reg();
$set['title']='хоккей';


require_once '../../sys/inc/thead.php';
title();
aut();
err();
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `hockey` " ), 0);




if($k_post==0)
{ 

echo"<div class = 'nav'>";
echo "Нет участников.<br />";

echo "</div>\n";
}


$q=mysql_query("SELECT * FROM `hockey` ORDER BY gol DESC LIMIT 100");

while ($post = mysql_fetch_array($q))
{

echo"<div class = 'nav1'>";

$ank=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = $post[id_user] LIMIT 1"));
	echo ($post['id_user'] != '0' ? user::avatar($ank['id'], 0) . user::nick($ank['id'], 1, 1, 1) : user::avatar(0, 0) . ' <b>' . 'Гость' . '</b> ');

echo "<br>
<font color=green>Команда:</font>\n";
echo"$post[team]";


echo "<br>
<font color=blue>Забито голов:</font>\n";
echo"$post[gol]";


echo "</div>\n";





}

echo"<div class = 'foot'>";

echo"<a href = index.php>Назад</a>";

echo "</div>\n";


require_once '../../sys/inc/tfoot.php';
?>