clankill3r Posted May 30, 2011 Share Posted May 30, 2011 this is the query: $query = "INSERT INTO kamerleden VALUES ('', '$twitter_id', '$name', '$nickname', '$fraction', '$residence', '$age', '$gender', '', '', '', '')"; it used to work but i switched to a different hosting. The first '' is the id which gives this error: query failed: Incorrect integer value: '' for column 'id' at row 1 in the database id is a int, with a length of 2 and with auto increment. How can i fix it? Quote Link to comment https://forums.phpfreaks.com/topic/237912-query-failed-incorrect-integer-value-for-column-id-at-row-1/ Share on other sites More sharing options...
harristweed Posted May 30, 2011 Share Posted May 30, 2011 You can fix it by using a valid insert query http://www.tizag.com/mysqlTutorial/mysqlinsert.php Quote Link to comment https://forums.phpfreaks.com/topic/237912-query-failed-incorrect-integer-value-for-column-id-at-row-1/#findComment-1222562 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.