第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

為了賬號(hào)安全,請(qǐng)及時(shí)綁定郵箱和手機(jī)立即綁定
已解決430363個(gè)問(wèn)題,去搜搜看,總會(huì)有你想問(wèn)的

來(lái)自數(shù)據(jù)庫(kù)的數(shù)據(jù)不正確

來(lái)自數(shù)據(jù)庫(kù)的數(shù)據(jù)不正確

PHP
至尊寶的傳說(shuō) 2021-10-22 13:29:40
我嘗試制作學(xué)生成績(jī)管理系統(tǒng)。當(dāng)我試圖根據(jù)每個(gè)學(xué)生在考試中獲得的總分來(lái)確定位置時(shí),我遇到了問(wèn)題。在我的輸出中,我得到 1st(獲得標(biāo)記 450)、2nd(獲得標(biāo)記 449)、4th(獲得標(biāo)記 448)。缺少第 3 個(gè)位置。5、10 和其他一些位置丟失。但是我在我的代碼中沒(méi)有發(fā)現(xiàn)任何問(wèn)題。if (!function_exists('get_position_in_exam')) {function get_position_in_exam($school_id, $exam_id, $class_id, $section_id, $mark) {    $ci = & get_instance();    $sql = "SELECT id, total_obtain_mark, FIND_IN_SET( total_obtain_mark,(            SELECT GROUP_CONCAT( total_obtain_mark  ORDER BY total_obtain_mark DESC )             FROM exam_results WHERE school_id = $school_id AND exam_id = $exam_id AND class_id = $class_id AND section_id = $section_id ))            AS rank             FROM exam_results            WHERE school_id = $school_id AND exam_id = $exam_id AND class_id = $class_id AND section_id = $section_id AND total_obtain_mark = $mark";     $rank =  @$ci->db->query($sql)->row()->rank;     if($mark == 0){        return '--';     }    if($rank == 1){        return $rank.'st';    }elseif($rank == 2){       return $rank.'nd';     }elseif($rank == 3){       return $rank.'rd';     }elseif($rank > 3 ){        return $rank.'th';             }else{        return '--';     }}}
查看完整描述

1 回答

?
慕桂英546537

TA貢獻(xiàn)1848條經(jīng)驗(yàn) 獲得超10個(gè)贊

您的子查詢中需要不同的 total_obtain_mark


GROUP_CONCAT( distinct total_obtain_mark  ORDER BY total_obtain_mark DESC )


"SELECT id, total_obtain_mark, FIND_IN_SET( total_obtain_mark,(

   SELECT GROUP_CONCAT( distinct total_obtain_mark  ORDER BY total_obtain_mark DESC ) 

   FROM exam_results WHERE school_id = $school_id AND exam_id = $exam_id AND class_id = $class_id AND section_id = $section_id ))

   AS rank 

   FROM exam_results

   WHERE school_id = $school_id AND exam_id = $exam_id AND class_id = $class_id AND section_id = $section_id AND total_obtain_mark = $mark";

否則,如果您有一些相同等級(jí)的學(xué)生,您將跳過(guò)位置


查看完整回答
反對(duì) 回復(fù) 2021-10-22
  • 1 回答
  • 0 關(guān)注
  • 175 瀏覽

添加回答

舉報(bào)

0/150
提交
取消
微信客服

購(gòu)課補(bǔ)貼
聯(lián)系客服咨詢優(yōu)惠詳情

幫助反饋 APP下載

慕課網(wǎng)APP
您的移動(dòng)學(xué)習(xí)伙伴

公眾號(hào)

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號(hào)