View Single Post
Old September 11th, 2006, 10:53 AM   #10 (permalink)
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,686
ALTER TABLE pp_photos auto_increment=SOMENUMBER;

You can not go by how many rows you have you need to view the last record and see the id and then set your auto_increment with the query above to that last records plus one.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote