ID: 15668 Updated by: [EMAIL PROTECTED] -Summary: translation of symbol '&' when storing in Mysql Reported By: [EMAIL PROTECTED] -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] [EMAIL PROTECTED] 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
