Re: Mysql update query involving many fields

[Josue Mora]

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"));

i hope help you..

Att. joshua
Zapopan,Jalisco,Méxcico
www.josue.dnsalias.com



----- Original Message -----
From: "Petr Vileta" <petr@stripped>
To: <win32@stripped>
Sent: Thursday, January 15, 2004 6:13 PM
Subject: Re: Mysql update query involving many fields


                   //Update DB.               Problem HERE! doesn't seem to
work, even php my admin proposed code gives an error.
                   $query = "UPDATE users SET level='$char_level',
strenght='$char_strenght', speed='$char_speed', stamina='$char_stamina',
iq='$char_iq', dodge='$char_dodge', h2h='$char_h2h',
wpskill='$char_wpskill', hp='$char_hp', chakra='$char_chakra' WHERE
login='$char_user_id' LIMIT 1";
                    mysql_query($query, $connection) or die(mysql_error());

I don't programming in PHP, but in Perl I must write somethink like this

$query = "UPDATE users SET level=\'$char_level\', ...

Test to escape  '  character in your variable $query or use character `

Sorry for html mail :-)

Petr Vileta, Czech republic