Updating fIle path in MySQL through PHP does not work

Answer 1

The backslash is in most environments an escape character. You've basically two solutions:

1. Use double backslash \\ to represent a single backslash.
2. Use forward slashes / instead (works perfectly in all platforms, including Windows and *NIX).

I would prefer solution 2 as it works everywhere and would minimize developer confusion.

Answer 2

I got it resolved. The only setting I had to make was this :

$set = mysql_query("set sql_mode='NO_BACKSLASH_ESCAPES';");

before updating.

Hope this helps others.