crmamx Posted February 4, 2011 Share Posted February 4, 2011 Using phpMyAdmin I loaded 6 test records with the id set to auto_increment and it loaded all the data correctly with id # 1-6. Then from somewhere it got the number 333353 and auto_increments it as the value for the id. So now I have id's 1-6 and 333353, 333354, ect. For every record I add it increments it. I deleted all but records 1-6 and tried again but it has the last value of 3333xx stored somewhere and increments it. Deleted them again, closed the program, came back and it still does it. Quote Link to comment https://forums.phpfreaks.com/topic/226631-phpmyadmin-picking-up-strange-value-from-somewhere/ Share on other sites More sharing options...
denno020 Posted February 4, 2011 Share Posted February 4, 2011 Try exporting the sql for the problem table and then create a new one. See if that helps. Quote Link to comment https://forums.phpfreaks.com/topic/226631-phpmyadmin-picking-up-strange-value-from-somewhere/#findComment-1169674 Share on other sites More sharing options...
QuickOldCar Posted February 4, 2011 Share Posted February 4, 2011 ALTER TABLE table_name AUTO_INCREMENT = 7; Quote Link to comment https://forums.phpfreaks.com/topic/226631-phpmyadmin-picking-up-strange-value-from-somewhere/#findComment-1169703 Share on other sites More sharing options...
crmamx Posted February 4, 2011 Author Share Posted February 4, 2011 Bingo! That's some deep stuff. My hosts phpMyAdmin could not fix it. I had two old fast cars, 68 and 69 AMX. Wish the hell I had kept them. Thanks a jillion. Quote Link to comment https://forums.phpfreaks.com/topic/226631-phpmyadmin-picking-up-strange-value-from-somewhere/#findComment-1169708 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.