Code Forums - View Single Post

trevor · 02-26-2003, 08:09 PM

anyone know how to change what auto_increment is set to?

I deleted a couple of posts on my news section of my site, and now whenever I post something, the ID is off by 2. So i have to change the ID -2 for the post to show up. (probably make more sense if you saw my code).

But anyways, if my news id's go up to 14, and I post something, the id for that thing is 17, so id have to change it to 15 for it to show.

hope that makes sense (its really late)

thanks,

Trevor

02-26-2003, 08:09 PM	#1 (permalink)
trevor Code Monkey Join Date: Jan 2003 Location: Canada Posts: 91	auto_increment anyone know how to change what auto_increment is set to? I deleted a couple of posts on my news section of my site, and now whenever I post something, the ID is off by 2. So i have to change the ID -2 for the post to show up. (probably make more sense if you saw my code). But anyways, if my news id's go up to 14, and I post something, the id for that thing is 17, so id have to change it to 15 for it to show. hope that makes sense (its really late) thanks, Trevor