I need to insert information which includes single apostrophes into a mysql database table A. The information is first extracted from another table B and inserted into table A via PHP ie by means of a web form. The original data cannot be altered by me as it is written by the client and uploaded by them to table B. I don't want to ask the client to use double apostrophes (eg O''Brien instead of O'Brien) as the information in table B has to be legible - also I think I will get problems with field separation as they are uploading their data by converting it to a textfile in which fields are enclosed by " (fields are separated by 😉.
I would be very grateful for any suggestions. Thank you. Philippa
