Re: [PHP-DB] Problem with symbol &

[Andrey Hristov]

The problem is that you probably use phpMyAdmin for editing data. 

Regards,
Andrey Hristov
----- Original Message ----- 
From: "Marco Coletta" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 25, 2002 10:08 AM
Subject: [PHP-DB] Problem with symbol &


> 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 '&amp;'.
> 
> 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
> 
> 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php