Hi All

I have to the Update query mulitple times for different parameters using for loop in my PHP Script, now the problem Is Whenever I do it, only my last query get executed, all the previous queries seems to be skipped. the loop goes like this:

foreach($cntrlflagset as $cntrlordoc => $cntrlorflag){
                for($t=0;$t<count($cntrlorflag);$t++){
                    $userlvl = "controller";

                    $docflag = 1;
                    $postfix = "created";
                    $createdoc->updatedocseeflags($cntrlorflag[$t],$docflag,$cntrlordoc,$postfix,$userlvl);
                    $docflag = 2;
                    $postfix = "midlvl";
                    $createdoc->updatedocseeflags($cntrlorflag[$t],$docflag,$cntrlordoc,$postfix,$userlvl);
                }
            }

Here, the called function

$createdoc->updatedocseeflags($cntrlorflag[$t],$docflag,$cntrlordoc,$postfix,$userlvl);

Contains the Update query:

$query = "UPDATE tbl_docuserstatus SET";
                //if($flag != ""){
                $query .= " docseeflag_".$postfix." = '".$flag."'";
                //}
                $query .= " WHERE doc_id = '".$doc_id."' AND user_id = '".$user_id."'";

                if($userlvl == "midlvl"){
         $query .= " AND doc_midlvluser = '1'";
        }elseif($userlvl == "finallvl"){
        $query .= " AND doc_finallvluser = '1'";
        }elseif($userlvl == "creator"){
        $query .= " AND doc_creator = '1'";
        }elseif($userlvl == "controller"){
        $query .= " AND doc_controller = '1'";
        }elseif($docarchive == 1){
        $query .= " AND doc_controller = '1'";
        }

So could some one tell me,

How to set the delay between update queries in Mysql so that every query get executed succesfully?

Thanks In Advance