problem z updata w mysqlu Opcje

[-ponti-]

[SQL] pobierz, plaintext 
$sql = "UPDATE users SET user_name='$user_name',  SET user_age='$user_age', SET user_city='$user_city', SET user_mail='$user_mail',  SET user_gg='$user_gg',  SET user_cpu = '$user_cpu',  SET user_ram = '$user_ram',  SET user_conn = '$user_conn',  SET user_maps = '$user_maps', SET user_weap = '$user_weap' WHERE user_id = '$usern'";
mysql_query($sql);
[SQL] pobierz, plaintext 

MAm takie zapytanie i nie działa (IMG:http://forum.php.pl/style_emoticons/default/sad.gif)
gdy skróce liczbe updatów do jednego to jest ok! co jest zle ?

[-Guest-]

PORADZILEM SOBIE BO NIKT NIE CHCIAL MI POMÓC!!!
TROCHE MALO WYDAJNIE TO ZROBILEM ALE DZIALA!

[SQL] pobierz, plaintext 
$sql = "UPDATE users SET user_name = '$user_name' WHERE user_id = '$usern'";
$sql2 = "UPDATE users SET user_age = '$user_age' WHERE user_id = '$usern'";
$sql3 = "UPDATE users SET user_city = '$user_city' WHERE user_id = '$usern'";
$sql4 = "UPDATE users SET user_mail = '$user_mail' WHERE user_id = '$usern'";
$sql5 = "UPDATE users SET user_gg = '$user_gg' WHERE user_id = '$usern'";
$sql6 = "UPDATE users SET user_cpu = '$user_cpu' WHERE user_id = '$usern'";
$sql7 = "UPDATE users SET user_ram = '$user_ram' WHERE user_id = '$usern'";
$sql8 = "UPDATE users SET user_conn = '$user_conn' WHERE user_id = '$usern'";
$sql9 = "UPDATE users SET user_maps = '$user_maps' WHERE user_id = '$usern'";
$sql10 = "UPDATE users SET user_weap = '$user_weap' WHERE user_id = '$usern'";
$sql11 = "UPDATE users SET user_pass = '$user_pass' WHERE user_id = '$usern'";
mysql_query($sql);
mysql_query($sql2);
mysql_query($sql3);
mysql_query($sql4);
mysql_query($sql5);
mysql_query($sql6);
mysql_query($sql7);
mysql_query($sql8);
mysql_query($sql9);
mysql_query($sql10);
mysql_query($sql11);
[SQL] pobierz, plaintext 

(IMG:http://forum.php.pl/style_emoticons/default/winksmiley.jpg)

[BzikOS]

Ou god!

Weź to wyrzuć i zastosuj pierwsze zapytanie, tylko usuń te SETy... Tak wyglądać ma zapytanie:

[SQL] pobierz, plaintext 
UPDATE tabela SET kolumna1 = 'wartosc1', kolumna2 = 'wartosc2' WHERE ....
[SQL] pobierz, plaintext