Importing CSV data into MYSQL via PHP : <p>I am working on a website which uses data from a CRM system, this data is in CSV format but when im trying to import into MYSQL via php something is corrupting and forcing a record to split and take 2 rows.  Example of CSV field below - something in it is causing the error/split to another row in the database.  It seems to be some kind of character but ive tried to replace the culprit ones.  Any ideas would be GREATLY appreciated as I have spent ages trying to figure this out!! im using fgetcsv to import.  I can import the csv file no problem via phpmyadmin</p>

<p>"GREAT FIRST TIME PURCHASE TWO BED END TERRACED IN A POPULAR LOCATION.  Pleased to have available this well presented two bed end terraced situated in an ideal location for all local amenities, just a short stroll to the Stretford Arndale Centre and close proximity to the Metrolink tram station for commuting into the city centre and Media city.  The accommodation briefly comprising, lounge with staircase leading to first floor, kitchen/diner and cellar used for storage.  Whilst to the first floor there are two double bedrooms and a family bathroom.  OUTSIDE Enclosed Court yard to the rear.  Private parking space."</p>
