Bug #3707: Inserting the ' char into a mysql table
| From: | ronen at aai dot co dot il | Date: | Thu, 02 Mar 2000 16:00:06 +0000 |
| Subject: | Bug #3707: Inserting the ' char into a mysql table | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-16279@lists.php.net to get a copy of this message | ||
From: ronen@aai.co.il
Operating system: Unix
PHP version: 3.0 Latest CVS (02/03/2000)
PHP Bug Type: MySQL related
Bug description: Inserting the ' char into a mysql table
It is not possible to insert the ' char (Ascii code = 39) into a mysql table.
for example:
$CooperationDescription = "children's books";
$setstring = " CooperationDescription = '$CooperationDescription' ";
$result = mysql ("password","UPDATE Tbl SET $setstring WHERE (CNumber = $CNumber)
");
in this case the data will not be inserted or updated .
and $result will be equal to "".
if you need more information please contact me :
E MAIL: ronen@aai.co.il
Please email to me an answer anyway.