siwelis Posted May 25, 2010 Share Posted May 25, 2010 I'm running a while statement to insert rows: i.e. { mysql_query("INSERT INTO Sprites (Sprite, SpriteID, SpriteName, SpriteImg) VALUES ('$spriteid', '$tag', '$tagname', '$firstimage')"); echo mysql_insert_id()."<br />\n"; } It echos: 136 137 138 139 140 141 141 141 141 Yet I check SQL and it's actually correct: It echos: 136 137 138 139 140 141 142 143 144 Anyone know how to fix this? Link to comment https://forums.phpfreaks.com/topic/202893-mysql_insert_id-skipping-ahead-bug/ Share on other sites More sharing options...
Mchl Posted May 25, 2010 Share Posted May 25, 2010 Can you show us table structure? SHOW CREATE TABLE Sprites Link to comment https://forums.phpfreaks.com/topic/202893-mysql_insert_id-skipping-ahead-bug/#findComment-1063271 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.