在PHP中逃避MySQL查询 - mysql_query（）更新什么都不做

Question

In my php script for a gallery, I need to update my table.
I am using the following code, but the code does nothing:

mysql_query(' "update gallery_photos set photo_caption = replace(photo_caption,"\\\'","\'") "');

Can you tell me how to get it to work or point me in the right direction?

Answer 1

Try this with removing single quotes at start and end.

mysql_query("update gallery_photos set photo_caption = replace( photo_caption,'\\\'','\'') ");