Re: Problem with symbol &

I edit with phpMyAdmin and Mascon, but if I look at the recodr with Mysql client I have the same result : in the record I find &amp; instead of & "Andrey Hristov" <ahristov@icygen.com> ha scritto nel messaggio news:00f401c1bdd4$7d3bec00$0b01a8c0@ANDreY... > The problem is that you probably use phpMyAdmin for editing data. > > Regards, > Andrey Hristov > ----- Original Message ----- > From: "Marco Coletta" <macolet@goldtelevision.com> > To: <php-db@lists.php.net> > 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 > > > > >