The problem was solved. The programmer used htmlspecialchars() in one of his functions. So the function was the problem. No problemas with phpMyAdmin - too clever.
Andrey ----- Original Message ----- From: "Jonathan Underfoot" <[EMAIL PROTECTED]> To: "[PHP-DB]" <[EMAIL PROTECTED]> Sent: Monday, February 25, 2002 3:37 PM Subject: Re: [PHP-DB] Problem with symbol & > In my experience PHPMyAdmin DOES NOT change anything. It never changes & > for me, and it dosen't addslashes(), which makes it a complete pain in the > ass to use, but better than changing things without your knowledge I > suppose. Maybe I'm using an old version? > > -Jonathan > ----- Original Message ----- > From: "Marco Coletta" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, February 25, 2002 3:42 AM > Subject: Re: [PHP-DB] Problem with symbol & > > > > It's not phpMyadmin that changed & to & but the PHP script. > > Than because I could not find with the PHP script the record I looked in > > with phpMyadmin. > > > > > > "Andrey Hristov" <[EMAIL PROTECTED]> ha scritto nel messaggio > > 010801c1bdd7$576e9dd0$0b01a8c0@ANDreY">news:010801c1bdd7$576e9dd0$0b01a8c0@ANDreY... > > > phpMyAdmin has changed & to & and then put it in the DB. > > > So it is better not to use phpMyAdmin or any toher web based tool for > > tasks which includes & entering. Not sure for <,> > > > > > > Regards, > > > Andrey Hristov > > > ----- Original Message ----- > > > From: "Marco Coletta" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Monday, February 25, 2002 10:32 AM > > > Subject: Re: [PHP-DB] 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 & instead of & > > > > > > > > > > > > "Andrey Hristov" <[EMAIL PROTECTED]> ha scritto nel messaggio > > > > 00f401c1bdd4$7d3bec00$0b01a8c0@ANDreY">news:00f401c1bdd4$7d3bec00$0b01a8c0@ANDreY... > > > > > 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 > > > > > > > > > > > > > > > > > > > -- > > 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
