Problem with symbol &
| From: | Marco Coletta | Date: | Mon, 25 Feb 2002 08:08:03 +0000 |
| Subject: | Problem with symbol & | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17249@lists.php.net to get a copy of this message | ||
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.
--