3
Contributors
4
Replies
27
Views
4 Years
Discussion Span
Last Post by GlenRogers
0

Not that I have tried but it seems possible that you can modify the auto-increment number

Have a look at this website Click Here

Alternatively, you could code the logic manually by increasing the id by one. For example, you're storing a first userID which normally starts as zero then increment it by one and finally store it in your table.

I hope this helps..

0

As far as I can see from the latest version of phpmyadmin, the operations panel, mentioned in the post referred to, only alters the start no. of the AI.
You could do something like

 $id=mysql_insert_id
 $newid=$id+2
 query=insert newid,etc

if you follow.

0

I just came accross this whilst looking for something else.
If I log into the database server on my free server (I use byethost) or locally on my dev copy, and click on the root link at the top, there's a tab labeled 'variables' And the first line is......(drum roll!)
'auto increment increment' just what you are looking for methinks!

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.