dootch Posted April 4, 2006 Share Posted April 4, 2006 I am using ftpget to get a price list and using LOAD DATA INFILE to upload it to a mysql db via a script problem is when the price is over 999.99 the price list's it as 1,000.00 with a comma in it. So all products over 1k load into the db as price 1.1 the column is set to decimal 15,2 I have tried to set it as varchar same thing any idea's. I would like this to be automated via a cron job Link to comment https://forums.phpfreaks.com/topic/6609-ftpget-and-load-data-infile-issue/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.