PHP and MSSQL VIA ODBC

From: Date: Thu, 19 Oct 2000 16:04:19 +0000
Subject: PHP and MSSQL VIA ODBC
Groups: php.general 
Request: Send a blank email to php-general+get-21185@lists.php.net to get a copy of this message
I have a MSSQL DB running, utilizing PHP to bring DB content to a website and from the website to write data to the DB. Here is my problem. I have a particular field that from the website will write/update a field on the DB. I need to allow PHP to write all characters including ', ", ` as part of an entry in this particular field in the DB. How would I write my query/statement to allow these characters to be recognize as a regular character (much like a regular letter entry)? and be written to my DB. In other words... $write-to-myDB = "INSERT INTO FIELD1 (CustID, Company, Address1) VALUES ('$psr', '$company', '$address1');"; What i want is, allow the variable $company to recognize the characters mentioned above and to be written to my DB. Right now if the value of $company = (Claudio's problem LLC); it will not recognize the ' on Claudio's and will not write it to my DB. Thanks for the help CC ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Claudio Cuestas

« previous php.general (#21185) next »