使用if条件对两列中的相同记录进行计数 - Count of same records from two columns using if condition

Count of same records from two columns using if condition

本文关键字：记录两列条件 if 使用 | 更新日期: 2023-09-27

我有一个表question_attempts。该表具有两列rightanswers和youranswer。

我想得到记录的计数rightanswer=youranswer。这实际上是我的全部代码。

$quizsections = mysql_query("SELECT * FROM quiz_sections");
while($quizsectionsrslt = mysql_fetch_array($quizsections)){
$quizsectionsid        = $quizsectionsrslt['id'];
$quizsectionsheading   = $quizsectionsrslt['heading'];
$quizsectionsquizid    = $quizsectionsrslt['quizid'];
$quizsectionsfirstslot = $quizsectionsrslt['firstslot'];
echo $quizsectionsheading."<br />";
$quizslots = mysql_query("SELECT * FROM quiz_slots WHERE `quizid`=$quizsectionsquizid LIMIT ".($quizsectionsfirstslot-1).", 10");
while($quizslotsrslt = mysql_fetch_array($quizslots)){
    $quizslotids = $quizslotsrslt['questionid'];
    $questions = mysql_query("SELECT * FROM question_attempts WHERE `questionid`=$quizslotids");
    $num_rows = mysql_num_rows($quizslots);
    while($answercount = mysql_fetch_array($questions)){
        $answercountrslt = $answercount['questionid'];
        echo $rightanswer = $answercount['rightanswer'];
        echo $youranser = $answercount['responsesummary']."<br />";
//Here want to display the count of rightanswer and count of wrong answer.
    }
    }
    echo "Total Questions : ".$num_rows."<br /><br />";
}

使用以下内容：

$rightanswercount=0;
$badanswercount=0;
    $questions = mysql_query("SELECT * FROM question_attempts");
        while($answercount = mysql_fetch_array($questions)){
    $rightanswer = $answercount['rightanswer'];
    $youranser = $answercount['youranswer'];
    if($youranser == $rightanswer)
            {
                $rightanswercount=$rightanswercount+1;
            }
            else
            {
               $badanswercount=$badanswercount+1;
            }
        }
echo "Right Count=".$rightanswercount;
echo "Bad Count=".$badanswercount;

如果你只想获得count，那么你可以使用mysql_num_rows

$questions = mysql_query("SELECT count(*) FROM question_attempts where rightanswers=youranswer");
$count=mysql_num_rows($questions);

您可以通过sql查询完成任务，并对正确答案执行操作

$questions = mysql_query("SELECT * FROM question_attempts where rightanswers=youranswer");
$count = mysql_num_rows($questions);
// $count is number of right answers
while($row = mysql_fetch_array($questions))
{
    // Stuff on right answers
}