php - My code run in loop

Question

I know this is not the kind of question that I can ask here but my code run in loop and I don't know why :

   while ($resultat = $resultats->fetch())
        {

           $checkBadMetier = $connexion->prepare("SELECT onetsoc_code
                                FROM badQuestionMetier
                                WHERE element_id = '$key' AND onetsoc_code='$resultat->onetsoc_code'");
            $checkBadMetier->execute(); //line 125!!
            $res = $checkBadMetier->fetch(PDO::FETCH_OBJ);
            if (count($res) > 0) {
                $jobTable[$resultat->onetsoc_code]=-900000;
            }

It's make the PHP timeout any idea why?

Fatal error: Maximum execution time of 120 seconds exceeded on line 125

Answer 1

Your loop might be endless. If it is not, you could extend the maximum execution time like this:

ini_set('max_execution_time', 300); //300 seconds = 5 minutes