I have a problem with symbol &. 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 '&'. The real problem is that if I do a query with where looking for the content of record where myvalue='Smith & Sons' in this case the symbol & is not translated and so the query has no success. -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
