Script petering out

[timstring]

this script rolls over and dies on my server where $q = 616, and even earlier on my laptop. $q is supposed to be around 900. I have used every ob_** command, and nothing seems to help.

for ($Count = 0; $Count < $NumMonth; $Count++) {

$date = date_create($StartDate);
date_add ($date, date_interval_create_from_date_string($Count . 'days'));
$IncDate = date_format($date, 'Y-m-d');

$stmt = $mysqli->prepare("SELECT IdNum FROM TOAWorkOrdersNew WHERE WorkDate = ? AND TechNum = ?");
$stmt->bind_param('ss', $IncDate, $TechNum);
$stmt->execute();
$stmt->store_result();

$WorkOrders = $stmt->num_rows;
$SubWorkOrders = $SubWorkOrders + $WorkOrders;

$stmt->free_result();
$stmt->close();



$stmt2 = $mysqli->prepare("SELECT IdNum FROM CallVolume WHERE WorkDate = ? AND ANI = ?");
$stmt2->bind_param('ss', $IncDate, $CellNum);
$stmt2->execute();
$stmt2->store_result();

$CallCount = $stmt2->num_rows;
$SubCallCount = $SubCallCount + $CallCount;

$stmt2->free_result();
$stmt2->close();


	   echo $q . ' qq ' . $Count . ' tn ' . $TechNum . ' cc ' . $CallCount . ' pp ' . $WorkOrders . ' xx ' . $CallCount . '<br>';

$q++;



flush();
ob_flush();



if ($SubCallCount > 0 || $SubWorkOrders > 0) {
	$ColorCount = $ColorCount + .5;
	if ($ColorCount == (int) ($ColorCount)) {
		$objPHPExcel->getActiveSheet()->getStyle($strRow)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
		$objPHPExcel->getActiveSheet()->getStyle($strRow)->getFill()->getStartColor()->setARGB('FFA9F5A9');
	}
else {
	$objPHPExcel->getActiveSheet()->getStyle($strRow)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
	$objPHPExcel->getActiveSheet()->getStyle($strRow)->getFill()->getStartColor()->setARGB('FFFFFFFF');
}


$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $iRow, $TechNum);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $iRow, $TechName);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $iRow, 'Calls');


$CellNum = $row["CellNum"];
$AreaCode = substr($CellNum,0,3);
$Exchange = substr($CellNum,3,3);
$PhNum = substr($CellNum,5,4);
$FormatCell = '(' . $AreaCode . ') ' . $Exchange . '-' . $PhNum;


$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $iRow+1, $FormatCell);
	$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow(1, $iRow) ->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);	
$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow(1, $iRow) ->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);


$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $iRow + 1, 'Work Orders');
	$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow(2, $iRow) ->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);	
$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow(2, $iRow) ->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);



$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($Count+3, $iRow, $CallCount);


$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($Count+3, $iRow) ->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);	
$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($Count+3, $iRow) ->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);



$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($Count+3, $iRow+1, $WorkOrders);
$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($Count+3, $iRow+1) ->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);	
$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($Count+3, $iRow+1) ->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);			

	}

}		
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($Count+3, $iRow, $SubCallCount);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($Count+4, $iRow+1, $SubWorkOrders);


			$SubCallCount = 0;
			$SubWorkOrders = 0;

ob_end_flush(); 
ob_flush(); 
flush(); 
ob_start(); 
					 }
			}

I know this code is rough. What can I do to make the script run to completion? If you want to see what I'm trying, go to http://www.bryanrails.com/classes/05featuredemo.php

Please type slowly, for I am a slow reader.

[laserlight]

You might need to use [man]set_time_limit/man if you are unable to optimise the script to run within the defined time limit.

By the way, one core idea of prepared statements is to prepare the statement once then run it many times with different values bound. As such, you should pull the preparation of those SQL statements to before the loop. Also, if you only want the row count, then a SELECT COUNT(IdNum) ... query may be better.