Bug #15668: translation of symbol '&' when storing in Mysql

From: macolet@goldtelevision.com Operating system: linux redhat 7.1 PHP version: 4.0.5 PHP Bug Type: MySQL related Bug description: translation of symbol '&' when storing in Mysql 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 bug report at http://bugs.php.net/?id=15668&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=15668&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=15668&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=15668&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=15668&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=15668&r=support Expected behavior: http://bugs.php.net/fix.php?id=15668&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=15668&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=15668&r=submittedtwice