[SOLVED] Duplicate Entry Issues

[jlp09550]

Hello.

 

I have been experiencing some 'duplicate entry issues' with my MySQL table.

First of all, I've tried removing the auto increasement that was on and use a manual PHP addition sentence, but to no avail.

 

The present coding:

$get_next_id = mysql_query("SELECT `id` FROM `====` ORDER BY `id` DESC LIMIT 1");
$get_next_id2 = mysql_fetch_array($get_next_id);
$getnextid = $get_next_id2['id']+1;

mysql_query("INSERT INTO `====` (id, ==,==,==,==) VALUES ('$getnextid', '==','==','==','==')") or die(mysql_error());

 

The error:

Duplicate entry for '127' on key 1

 

Thanks.

 

P.S. The output from the above coding is 128, yet the query thinks it is 127 for some reason. Not sure why.