php - 如何检查mysql在while循环中获取的行是否相同

Question

如何检查 while 循环的结果行值是否相同，我需要在所有结果的状态完成时进行更新...

        $result = $db->query("SELECT * FROM fy_working_staf_cstm WHERE task_id_c='".$t_id."'");
        while($row = $db->fetchRow($result)){
          ++$tas;
            $staff_id=$row['id_c'];
            $result1 = $db->query("SELECT `status` FROM `fy_working_staf` WHERE id='".$staff_id."' AND `status`='Completed'");
            $staf = $db->fetchByAssoc($result1);
            $status = $staf['status'];
            if($stat=='Completed')
             {
                ++$tas1;
                //$comple_staus='Closed_Closed';
             }
        }
        if(($tas == $tas1) && ($tas1 !=0) )
        {
            $q = $db->query("UPDATE `tasks` SET `status`='Completed' WHERE id='".$t_id."' ");
            $st = $db->fetchByAssoc($q);    
        }

Answer 1

相反，我可以在其中使用中断条件:

  while($row = $db->fetchRow($result)){
        $staff_id=$row['id_c'];
        $result1 = $db->query("SELECT `status` FROM `fy_working_staf` WHERE id='".$staff_id."' AND `status`='Completed'");
        $staf = $db->fetchByAssoc($result1);
        $status = $staf['status'];
        if($stat!='Completed')
         {
            $comple_staus='Closed_Closed';
            break;// will exit the loop when the row is not same

         }
    }