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
