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

Reply via email to