I am using PHP-4.0.7-dev with MySQL 3.23.39 and on some tables with auto increment fields when I INSERT a new record the auto-incremented field goes to 2147483647 instead of the next increment value.. The other numbers are all fine, there is nothing odd I can see here...
here is the query / code snippet:
$NewPassword = md5($newpassword);
$user_regdate = date("M d, Y");
$query = "INSERT INTO users (user_id, username, user_regdate, user_password, user_email, user_level, user_fullname,
user_gamename) VALUES ('', '$newusername', '$user_regdate', '$NewPassword', '$myemail', '$useraccesslevel', '$myname', '$mygamename')";
user_id int(11) No auto_increment
It does it from phpMyAdmin too when I try to add to certain tables.. Other tables work fine... Any ideas? Thanks!
here is the query / code snippet:
$NewPassword = md5($newpassword);
$user_regdate = date("M d, Y");
$query = "INSERT INTO users (user_id, username, user_regdate, user_password, user_email, user_level, user_fullname,
user_gamename) VALUES ('', '$newusername', '$user_regdate', '$NewPassword', '$myemail', '$useraccesslevel', '$myname', '$mygamename')";
user_id int(11) No auto_increment
It does it from phpMyAdmin too when I try to add to certain tables.. Other tables work fine... Any ideas? Thanks!