0";
}else{
$kkk=$nianji;
$string="select uid from Sch_Paihang where nianji='".$nianji."' and answers>0";
}
$amount=$conn->get($string);
if ($mmm){
$title1=$kkk."年级(".$krr[$mmm-1].")科目成绩排行榜";
$tableName1="成绩";
}else{
$title1=$kkk."年级总成绩排行榜";
$tableName1="总成绩";
}
?>
SmartBees
排名
姓名
所在学校
答题次数
0";
$string.=" order by Sch_Paihang.kemu".$mmm." desc";
}else{
$string="select Sch_Paihang.score as score,Sch_Paihang.answers as answers,Sch_User.name,Sch_User.xuexiao from Sch_Paihang inner join Sch_User on Sch_Paihang.uid=Sch_User.id where Sch_Paihang.nianji='".$kkk."' and Sch_Paihang.answers>0";
$string.=" order by Sch_Paihang.score desc";
}
$string=$string." limit ". ($page-1)*$page_size .", $page_size";
$query=$conn->query($string);
$i=($page-1)*10+1;
$j=$i;
while ($result=$conn->fetch_array($query))
{
$name=$result['name'];
$xuexiao=$result['xuexiao'];
$score1=$result['score'];
$score2=$result['answers'];
if ($score1<50){
$color1="#ff0000";
}else{
$color1="#009900";
}
?>
