|
TOP TEN
STT |
Họ và tên |
Email |
Thời gian(ms) |
Tổng điểm |
$sql = "SELECT uid,mamt,diem*1 as diem1,socauchon,hoten,tongthoigian*1 as tongtg from ketqua where idmon='".$mamt;
$sql .="' group by uid order by diem1 DESC, tongtg ASC LIMIT 0,10";
$rs=mysql_query($sql);
$n=mysql_num_rows($rs);
for ($m=0;$m<$n;$m++)
{
$r=mysql_fetch_array($rs);
$i=$m+1;
echo " ";
echo " ".$i." | ";
echo " ".$r['hoten']." | ";
echo " ".$r['uid']." | ";
echo " ".$r['tongtg']." | ";
echo " ".$r['diem1']." | ";
echo " ";
}
mysql_close();
echo " ";
include("footer.inc");
?>
| |