On Tue, 2 Sep 2003 16:45:28 +0100, Craig Cameron wrote: > >Ok simple problem I hope. > > >Have the following code, used to store the location and a few details about meeting minutes. > ><snip> > $connection = mssql_connect("server","user","password"); > mssql_select_db("DocumentManager",$connection); > > $AlteredMinutesLocation = str_replace("\\","\",$MinutesLocation); > > $SQL_STRING = "INSERT INTO tblMeetingMinutes VALUES('$Date','$Type','$AlteredMinutesLocation','$Centre')"; > > $Result = mssql_query($SQL_STRING,$connection); > mssql_close($connection); > ></snip> > >Problem is the backslashes. When I collect the filepath ($Location) it puts \\ into the db. However, when I change this it stops dead. Basically due to the escape charateristics of the backslash. I can get around this with single quotes of course but can't put these in the SQL_STRING as it falls down there then! > >Somebody must have come across this before, any help much appreciated. > >Cheers > >Craig > Try using the built-in functions addslashes() and stripslashes(). Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php