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 Quote Link to comment https://forums.phpfreaks.com/topic/6609-ftpget-and-load-data-infile-issue/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.