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

Reply via email to