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

Reply via email to