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