auto increment starts at 6777220

[scheetz]

I am having a problem with the auto increment of my user_id field. user_id is set as auto increment and it works fine except it starts at 677220. user_id is a primary key, auto increment, INT. There are only two entries before it in the table and they are user_id 1 and 2. Using mysql.

        $query2 = "INSERT INTO phpbb_users (user_id, username, user_regdate, user_email, user_password, user_viewemail) 
             VALUES (0, '$username', '$regdate', '$email', '$encrypted_password', 0)";

Thanks
scheetz

[lastuser]

When you have a primary key (user_id, int) you don´t have to insert information to it. So have you tried just

$query2 = "INSERT INTO phpbb_users (username, user_regdate, user_email, user_password, user_viewemail)
VALUES ('$username', '$regdate', '$email', '$encrypted_password', 0)";

User_id should work automatic.