Re: Mysql update query involving many fields

[Petr Vileta]

From: "Josue Mora" <josue@stripped>
To: "Petr Vileta" <petr@stripped>
Cc: <win32@stripped>
Sent: Friday, January 16, 2004 1:23 AM
Subject: Re: Mysql update query involving many fields


> Petr,
>
> It´s my example:
>     $query = "update shirt set
> style='{$HTTP_POST_VARS['style']}',color='{$HTTP_POST_VARS['tcolor']}'
WHERE
> id='$renglon2'";
>     $result = mysql_query($query) or die (error("Query failed"));
>
Test this please:
$query = "update shirt set
style=`{$HTTP_POST_VARS['style']}`,color=`{$HTTP_POST_VARS['tcolor']}` WHERE
            id=`$renglon2`";

or this:
$query = "update shirt set
style=`$HTTP_POST_VARS['style']`,color=`$HTTP_POST_VARS['tcolor']` WHERE
            id=`$renglon2`";

I don't understand what PHP mean by using {} brackets :-)
For MySQL character values is better to use ` character (on keyboard left
from the 1/! key). What is the english name for this? Accute accent? The
code value is #96 (Alt+96) or 0x60h.

Petr Vileta, Czech republic