Deleting Question

[lorddraco98]

I have a news script, and one part of it lets you delete an article.
Once this happens though, it messes up the newsid column in my DB(MySQL). It's an auto_incrament table and it starts giving out wierd numbers when i delete an entry. Any help on this?

[gtibok]

hi

Use the opimize table option for MySQL:

$optimize = "OPTIMIZE TABLE tbl_name[,tbl_name]...";
//and simply run this string as a MySQL query 
...................
$del = mysql_query("DELETE FROM tbl_name where ...");
$opt = mysql_query($optimize);
//this should help