= '$total_dat' AND user_quiz_avr5 >= '$total_avr') order by user_quizok_dat5 desc , user_quiz_dat5 desc LIMIT $limit_start,$limit_end", $connect);
$total=mysql_num_rows($result);
$start = $limit_start +1;
echo ("
퀴즈 랭킹 보기
");
echo ("
|
순위
|
이 름
|
객관식정답수
|
자기 소개
|
");
$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_dat5 = mysql_result($result,$count,"user_quizok_dat5");
$user_quiz_dat5 = mysql_result($result,$count,"user_quiz_dat5");
$user_num = mysql_result($result,$count,"no");
$user_intro = mysql_result($result,$count,"comment");
$user_quizok_dat5_2 = mysql_result($result,$count,"user_quizok_dat5_2");
//$user_quizok = mysql_result($result,$count,"user_quizok");
//문제수 저장
$user_quizok = $user_quizok_dat5 + $user_quizok_dat5_2;
//mysql_query("update $user_table set $quiz_userok where (user_id = '$user_id' and password=password('$password'))",$connect) or error('데이터베이스 처리에러2');
// 평균 처리
$temp = "user_quiz_avr5";
include "basic.inc.php3";
$connect=mysql_connect("$host_name","$user_name","$db_pass");
mysql_select_db("$db_name",$connect);
$user_table = zetyx_member_table ;
mysql_query("update $user_table set $temp='$avr_count' where (user_id = '$user_id' and password=password('$password'))",$connect) or error('데이터베이스 처리에러');
if ($user_quiz_dat5 == 0) {
$avr = 0;
}
else {
$avr = mysql_result($result,$count,"user_quiz_avr5");
}
echo ("
|
$num
|
");
if ($user_id == $user_idd) {
echo ("
");
}
echo ("
$users_name
|
$user_quizok_dat5
|
$user_intro
|
");
$count = $count+1;
endwhile;
// 데이터베이스에서 자료 꺼내오기
//$result=mysql_query("select * from $user_table where user_quiz_dat5 >= $p order by user_quizok_dat5_2 desc , user_quiz_dat5 desc LIMIT $limit_start,$limit_end", $connect);
//$total=mysql_num_rows($result);
$result=mysql_query("select * from $user_table where (user_quiz_dat5 >= '$total_dat' AND user_quiz_avr5 >= '$total_avr') order by user_quizok_dat5_2 desc , user_quiz_dat5 desc LIMIT $limit_start,$limit_end", $connect);
$total=mysql_num_rows($result);
echo ("
☞ 랭킹보기 - 동점일때는 더많은 문제를 풀어본 회원이 높은 순입니다
|
순위
|
아이디
|
이 름
|
주관식정답수
|
총정답수
|
출석교회
|
");
$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_dat5 = mysql_result($result,$count,"user_quizok_dat5");
$user_quiz_dat5 = mysql_result($result,$count,"user_quiz_dat5");
$user_num = mysql_result($result,$count,"no");
$user_intro = mysql_result($result,$count,"comment");
$user_quizok_dat5_2 = mysql_result($result,$count,"user_quizok_dat5_2");
$user_jumin = mysql_result($result,$count,"church");
//$user_quizok = mysql_result($result,$count,"user_quizok");
//문제수 저장
$user_quizok = $user_quizok_dat5 + $user_quizok_dat5_2;
//mysql_query("update $user_table set $quiz_userok where (user_id = '$user_id' and password=password('$password'))",$connect) or error('데이터베이스 처리에러2');
// 평균 처리
$temp = "user_quiz_avr5";
include "basic.inc.php3";
$connect=mysql_connect("$host_name","$user_name","$db_pass");
mysql_select_db("$db_name",$connect);
$user_table = zetyx_member_table ;
mysql_query("update $user_table set $temp='$avr_count' where (user_id = '$user_id' and password=password('$password'))",$connect) or error('데이터베이스 처리에러');
if ($user_quiz_dat5 == 0) {
$avr = 0;
}
else {
$avr = mysql_result($result,$count,"user_quiz_avr5");
}
echo ("
|
$num
|
");
if ($user_id == $user_idd) {
echo ("
");
}
echo ("
$user_idd
|
$users_name
|
$user_quizok_dat5_2
|
$user_quizok
|
$user_jumin
|
");
$count = $count+1;
endwhile;
echo ("
돌아가기
");
mysql_close($connect);
exit;
?>