Member Avatar for Prov1

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.

Edited by Prov1
  • 3 Contributors
  • 2 Replies
  • 94 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by broj1

Recommended Answers

All 2 Replies

Member Avatar for IIM

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

Member Avatar for broj1

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.