Please help me, i've been staring at this for the past 8 hours trying to figure out where the problem is. Below is the echo of the sql statement.
INSERT INTO venzo_emusic_sales(site, start_date, end_date, config, sale_type, original_sales_date, royaltor_code, royaltor_name, emusic_track_id, album_id, disc_#, track_#, track_name, artist_name, upc, isrc, release_album_name, iso, pin_code, cma, cma_id, units, alc_minima, retail_price, emusic_wholesale_minima, price_basis, gross_unit_rate_@_60%, gross_amount_due_@_60%, dpd_deductions_@_60%, net_unit_rate, total_track_sales_due, total_album_sales_due, cma_refund_unit_rate, total_cma_refunded, total_royalty_earned, currency) VALUES ('EMCA', '6/1/2012', '6/30/2012', 'T', 'S', ' ', '429396', 'MIKHAEL / WaTunes', '35099592', '13471715A', '1', '1', 'ALONE IN THE RIVER (LOOKING FOR ME)(RM)', 'ACAD STUDIO', '872836586146', 'Usmik1283801', 'SOLITUDES (REMASTERED)', 'CA', ' ', 'N', ' ', '1', '0.000000000000', '0.000000000000', '0.000000000000', ' ', '0.385015788919', '0.385015788919', '0.043965768000', '0.341050020919', '0.341050020919', '0.000000000000', '0.000000000000', '0.000000000000', '0.341050020919', 'USD')
The decimal numbers are being stored in a float column (float(12,12)). I tried the same number using the decimal datatype, but no joy there either. I tried rounding the number and that didn't work. All it keeps telling me is
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1p
The code for this isn't any different than any of the other sales pages i've done, so i really don't get why this is being a huge pain the rear.