Bug #15668 Updated: translation of symbol '&' when storing in Mysql
| From: | sander@php.net | Date: | Fri, 22 Feb 2002 17:20:59 +0000 |
| Subject: | Bug #15668 Updated: translation of symbol '&' when storing in Mysql | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-835@lists.php.net to get a copy of this message | ||
ID: 15668
Updated by: sander@php.net
-Summary: translation of symbol '&' when storing in Mysql
Reported By: macolet@goldtelevision.com
-Status: Open
+Status: Feedback
Bug Type: MySQL related
Operating System: linux redhat 7.1
PHP Version: 4.0.5
New Comment:
Can you provide a sample script? You're very likely doing something
wrong...
Previous Comments:
------------------------------------------------------------------------
[2002-02-22 02:58:56] macolet@goldtelevision.com
In PHP script I have a variable with a string assigned containing the
symbol '&' :
$myvariable = 'Smith & Sons';
when I insert the variable in the database :
$query="insert into mytable (mycolumn) values
(myvalue1='$myvariable');";
$result=mysql_query($query);
if I edit directly the column in Mysql the symbol '&' has been
translated to '&'.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=15668&edit=1