joshgarrod Posted July 24, 2007 Share Posted July 24, 2007 HI GUYS, I HAVE .CSV FILE CONTAINING DATA TO ADD INTO MY TABLE IN MY DATABASE, HOW EVER I HAVE NEVER DONE IT BEFORE AND IT KEEPS GIVING ME THE ERROR Error Invalid field count in CSV input on line 1. WHAT AM I DOING WRONG HERE. HERE IS THE LINK TO MY .CSV FILE SOME PLEASE HELP http://www.stowmarketcaravans.co.uk/stock.csv Link to comment https://forums.phpfreaks.com/topic/61547-phpmyadmin-help-please/ Share on other sites More sharing options...
piznac Posted July 24, 2007 Share Posted July 24, 2007 The field count in your csv does not match up to the database field count. It might not be putting a comma in the last field. Link to comment https://forums.phpfreaks.com/topic/61547-phpmyadmin-help-please/#findComment-306321 Share on other sites More sharing options...
joshgarrod Posted July 24, 2007 Author Share Posted July 24, 2007 ok so what do i need to do to solve this Link to comment https://forums.phpfreaks.com/topic/61547-phpmyadmin-help-please/#findComment-306323 Share on other sites More sharing options...
piznac Posted July 24, 2007 Share Posted July 24, 2007 you would need to compare the number of fields in both the csv and the db. Make sure they are exact. Link to comment https://forums.phpfreaks.com/topic/61547-phpmyadmin-help-please/#findComment-306324 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.