How to insert texts that contain apostrophe?
Posted: Fri Nov 05, 2004 9:41 am
Here's what I'm trying to do. I'm trying to insert this:
ljCharlie
and the error is:INSERT INTO photoGallery (sectionID,fileName,path,category,description,comments,insertDate) VALUES (8,'Reunion282.jpg','images/gallery','current',''53 '54 '55 Basketball Reunion',NULL,'2004-11-05')
So I'm guessing it has to do with the apostrophes that are in the '53 '54 '55. How do I solve this problem so that I can insert the apostrophes but get rid of this error?You have an error in your SQL syntax near '53 '54 '55 Basketball Reunion',NULL,'2004-11-05')' at line 1
ljCharlie