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? 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 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
Archived
This topic is now archived and is closed to further replies.