Home › Forums › Back End › Reset ID(int) to last + 1? › Re: Reset ID(int) to last + 1?
February 2, 2012 at 2:39 pm
#96039
Member
Try my first method so
mysql_query(‘DELETE from memes WHERE id = ‘.$img2del);
$sql=’SELECT MAX(id) AS max FROM memes’;
$query = mysql_query($sql);
$result = mysql_fetch_array($query);
$resetcount = $result+1;
$sql = ‘ALTER TABLE memes AUTO_INCREMENT=’.$resetcount;
$query = mysql_query($sql);
echo(“Image deleted”);
?>