dropfaith Posted October 24, 2008 Share Posted October 24, 2008 title says it all i just need to reset the auto index Id back to 1 i added some new features to my site and the ids need to be auto incremented along with the article Id so if user does article 1 rating adds an Id of 1 yes i have phpmyadmin cuase currently my article id Is 38 even tho i have no artlcles from all the tests ive done Link to comment https://forums.phpfreaks.com/topic/129933-solved-reset-auto-index/ Share on other sites More sharing options...
otuatail Posted October 24, 2008 Share Posted October 24, 2008 If you are resetting back to 1 then you pribably need an empty table. There would be a problem if the database tried to duplicate an ID. Easyest way for me is to go to phpMyAdmin and when the table is empty go to Operations on the top. You can set the value of one there. Desmond. Link to comment https://forums.phpfreaks.com/topic/129933-solved-reset-auto-index/#findComment-673639 Share on other sites More sharing options...
fenway Posted October 24, 2008 Share Posted October 24, 2008 You don't *need* to at all. Link to comment https://forums.phpfreaks.com/topic/129933-solved-reset-auto-index/#findComment-673782 Share on other sites More sharing options...
nadeemshafi9 Posted October 24, 2008 Share Posted October 24, 2008 i found that emptying the table resets it, or you can take ioff teh auto inc and then re number each one and then turn it back on, but you have to empty it, i do rember seeing a button at some point saying reset on the auto inc Link to comment https://forums.phpfreaks.com/topic/129933-solved-reset-auto-index/#findComment-673797 Share on other sites More sharing options...
dropfaith Posted October 24, 2008 Author Share Posted October 24, 2008 i just ended up starting the auto index at a higher number then my highest result Operations on the top Link to comment https://forums.phpfreaks.com/topic/129933-solved-reset-auto-index/#findComment-673800 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.