Arkane Posted August 28, 2009 Share Posted August 28, 2009 Hey guys, I've been playing about, trying to move a bunch of things into a MySQL database from XML. I've gotten the backbone written, but having problems actually getting it to import. I'm not sure if I've missed something in config or whatever, but its not working for me. mysql_query("INSERT INTO $table VALUES ('', '$name', '$age', '$email')"); The table fields are all VARCHARs, except for the first, which is an INT, set to unsigned and auto-inc. I've copied this from another I've done previously on a different host, so I guess that may be the problem. Basically, it doesn't add unless I specify what the first is to be set to, but it works fine on the other site. MySQL version is 5.1.37, and the error I'm getting is "Incorrect integer value: '' for column 'id' at row 1" Basically can anyone tell me what would make my db automatically fill the field... or perhaps why it works on one and not the other? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/172315-help-inserting-an-auto-inc-field/ Share on other sites More sharing options...
rhodesa Posted August 28, 2009 Share Posted August 28, 2009 use NULL: mysql_query("INSERT INTO $table VALUES (NULL, '$name', '$age', '$email')"); Quote Link to comment https://forums.phpfreaks.com/topic/172315-help-inserting-an-auto-inc-field/#findComment-908559 Share on other sites More sharing options...
fenway Posted September 7, 2009 Share Posted September 7, 2009 Actually, specify a column list without mentioning the auto-inc field, and you won't need NULL at all. Quote Link to comment https://forums.phpfreaks.com/topic/172315-help-inserting-an-auto-inc-field/#findComment-914132 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.