*sigh* timing out. help pls.

[slightlyeskew]

Hey guys! Could you check through this and see why its screwing up? I'm timing out at 600 seconds and I don't think it should take that long.

Its a that (for the most part) increments by one, going up to 2800 or so.
I pull the last ID first. Then I pull the full list of IDs. I count through the list to find areas where the list is not incremented by one. I check to make sure that the next number is not lower than the number before it, and I display the numbers that are "missing" in the list. So I'm checking to make sure the list increments by one, and where it doesn't I display the number. My data starts at 1 and ends at 2801. Help my newbness pls! Thanks for your time as always.

$lastID = $db->query("SELECT TransactionID FROM TransactionHistory ORDER BY TransactionID DESC LIMIT 1");
$lastOne = $lastID->fetchAll();

$bogglePull = $db->query("SELECT TransactionID FROM TransactionHistory ORDER BY TransactionID");
$everything = $bogglePull->fetchAll();

$current = 0;
$counter = 0;
$finalID = $lastOne;
while($current != $finalID)
{
//i want to increment through and see if it goes up by one.
$current = $everything[$counter];
$counter++;
	$incrementFactor = $counter;
	if($incrementFactor <= $current)
	{
		while($incrementFactor != $current)
		{
                 echo $incrementFactor;
                 echo " ";
		$incrementFactor++;//eventually equaling current, finshing the loop.
		}
	}
	else{echo "number failure!!";}

}

[Res]

With so few records it shouldn't be timing out. I suspect you are missing the counter conditional causing it to loop forever. Try echoing out your counters and killing the script before it loops, if those look ok let it run a few iterations and echo the counters each loop to make sure they are incrementing as expected.

[johanafm]

// Your problem is on these two lines
while($current != $finalID)
{
	$current = $everything[$counter];

You are in effect always comparing a row array ($current) to an array containing the array of the last row ($finalID is in other words no id, nor is it even the array of the last row.

If you inspect what those two contain using print_r, you should find something similar to this

$a1 = array(array('transactionID' => 1), array('transactionID' => 2 ),array('transactionID' => 4));
$lastId = array(array('transactionID' => 4));

if ($a1[2] == $lastId)
{
	echo '$a1[2] == $lastId';
}
else
{
	print_r($a1[2]);
	echo ' is NOT the same as ';
	print_r($lastId);
}

And why not simply

foreach ($everything as $row)
{

}