Re: Mysql update query involving many fields

[Petr Vileta]

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