Auto Increment

[dudejma]

I'm trying to make it create user logins. I'm wanting it to be where once the user registers, it automatically creates a login ID, but I'm wanting it to start at a certain number. How would I do this? With auto increment or with something in the code. I'm fairly new to PHP and MySQL so excuse my ignorance. Thanks.

[fugix]

If you are storing your user data into a database, which it sounds like you are, you can create a field as an int, primary key and auto-increment, and set that as your user id which will be unique

[requinix]

In your CREATE TABLE you can set the AUTO_INCREMENT value:

CREATE TABLE table (...) AUTO_INCREMENT = 1234;

If it exists then you can use ALTER TABLE:

ALTER TABLE table AUTO_INCREMENT = 1234;