I have the following PHP code:
Code: Select all
$previtemid = 0; // Meaning we always start with minimum ItemID of 1
$itemid = -1;
$breakout = FALSE;
while($row = mysql_fetch_array($result) && $breakout == FALSE)
{
if( $row['ItemID'] != $previtemid + 1)
{
$itemid = $previtemid + 1;
$breakout = TRUE;
}
$previtemid = $row['ItemID'];
}
if( $itemid == -1 )
{
$itemid = $previtemid + 1;
}However, from the error messages I am getting this algorithm tries to allocate a new ItemID of 1, when 1 is occupied, and I'm not sure why.
Can anyone explain?
Many thanks
Mark