I'm trying to import a csv file that has a currency field into a mysql database, but for some reason the import only brings in zero's. I'd like to have this data imported as a decimal with two decimal places.
How should I format my insertion query to accomplish this? Currently, it looks something like this:
$sql = "INSERT INTO database SET
`SalePrice` = '".database_safe($record["SalePrice"])."';
The format string for the file is "csv|44|1|34".
Any help is appreciated.