Re: Insert path string into Mysql

On Monday, November 18, 2002, at 01:10 PM, Alan Kelly wrote:

$path = 'c:\\demo\\' ; $query = "insert into PH_PHOTO (PHOTO_PATH) VALUES ('$path')"; $result=mysql_query($query);

I would guess that the backslashes are being interpreted once by php when the variable $path is interpolated into the query string (to become c:\demo\) and again by mysql at which point it tries to insert a value for \d. You might try $path = 'c:\\\\demo\\\\' and see if that works. Or maybe leave the path alone and do the query line like this: $query = "insert into PH_PHOTO (PHOTO_PATH) VALUES ('" . $path . "')"; -Steve