= '$total_dat' AND user_quiz_avr_philemon >= '$total_avr') order by user_quizok_dat_philemon desc , user_quiz_dat_philemon desc LIMIT $limit_start,$limit_end", $connect);
$total=mysql_num_rows($result);
$start = $limit_start +1;
echo ("
퀴즈 랭킹 보기
");
echo ("
☞ 랭킹보기
↓ $start 등 부터 $total_dat 문제이상 풀었고 평균이 $total_avr 점 이상인 회원 $total 명
|
번 호
|
아이디
|
이 름
|
정답수
|
총문제수
|
평 균
|
출석 교회
|
자기 소개
|
|
");
$count=0;
$limit_s = $limit_start +1;
while($count < $total):
//$num = $count+1;
$num = $limit_s + $count;
$user_idd = mysql_result($result,$count,"user_id");
$users_name = mysql_result($result,$count,"name");
$user_quizok_dat_philemon = mysql_result($result,$count,"user_quizok_dat_philemon");
$user_quiz_dat_philemon = mysql_result($result,$count,"user_quiz_dat_philemon");
$user_num = mysql_result($result,$count,"no");
$user_intro = mysql_result($result,$count,"comment");
$user_jumin = mysql_result($result,$count,"church");
if ($user_quiz_dat_philemon == 0) {
$avr = 0;
}
else {
$avr = mysql_result($result,$count,"user_quiz_avr_philemon");
}
echo ("
|
$num
|
$user_idd
|
$users_name
|
$user_quizok_dat_philemon
|
$user_quiz_dat_philemon
|
$avr
|
$user_jumin
|
$user_intro
|
|
");
$count = $count+1;
endwhile;
echo ("
돌아가기
");
mysql_close($connect);
exit;
?>