I have a php script that imports a csv into a sql db, seems to be work fine with the exception if the value of the cell is greater than 999, I assume that when the value is 1000, an extra "," is being inserted (1,000) and making my number of cells to be imported greater than what I am actually trying to import.
Sorry for such a basic question, just can't seem to figure this out.
Thanks in advance.

Recommended Answers

Please show your code so that i can help you in this.Show how you are converting csv into sql

Jump to Post

All 2 Replies

Please show your code so that i can help you in this.Show how you are converting csv into sql

And also post a few sample rows of csv file, especially the ones that cause problems.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.