"; #if ( $radr != $ipok ) { exit; }; $hostname = "localhost"; $username = "vva"; $password = "olis34x"; $dbName = "uz_vva"; $userstable = "vict_res"; MYSQL_CONNECT($hostname,$username,$password) OR DIE("Не могу создать соединение "); @mysql_select_db("$dbName") or die("Не могу выбрать базу данных "); print 'Admin '; $i=0;while ( $i < 2 ) { $query = "SELECT level,vict,avg(res) from $userstable WHERE level=$i group by vict order by 2 ASC"; $result = MYSQL_QUERY($query); echo ''; while(($rs=mysql_fetch_array($result))){ $p=sprintf("%4.2f",$rs[2]*20); echo ""; #echo ""; }; # while echo "
$rs[0]$rs[1]$p%
$l$v$p
"; $i++; }; # while i<2 $query = "SELECT id from $userstable WHERE level = 0 and vict = 1"; $result = MYSQL_QUERY($query); $k = MYSQL_NUMROWS($result); print "0 1 $k
"; $query = "SELECT id from $userstable WHERE level = 1 and vict = 1"; $result = MYSQL_QUERY($query); $k = MYSQL_NUMROWS($result); print "1 1 $k
"; $query = "SELECT id from $userstable WHERE level = 1 and vict = 2"; $result = MYSQL_QUERY($query); $k = MYSQL_NUMROWS($result); print "1 2 $k
"; mysql_close(); print ''; ?>