Forums

The forums ran from 2008-2020 and are now closed and viewable here as an archive.

Home Forums Back End Reset ID(int) to last + 1? Re: Reset ID(int) to last + 1?

#96039
bungle
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”);
?>