Update Problem

[vegnadragon]

Ok, here is what i got first

 

$send_enemy_jutsu = implode(",",$enemy_jutsu);

 

$query = "UPDATE `phpbb`.`game_status` SET temp_store = (`$send_enemy_jutsu`) WHERE `game_status`.`id_ref` = $enemy_id LIMIT 1";

 

$db->sql_query($query);

 

 

my error is

 

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,1,1,1 WHERE `game_status`.`id_ref` = 2 LIMIT 1' at line 1 [1064]

 

SQL

 

UPDATE `phpbb`.`game_status` SET temp_store = 1,1,1,1,1 WHERE `game_status`.`id_ref` = 2 LIMIT 1

 

 

Apparently i can't seem to store 1,1,1,1,1 in temp_store. i putted in between (), '', `` none of them worked .

 

Any solution ?

[php_dave]

Try,

 

$query = "UPDATE `phpbb`.`game_status` SET temp_store = ('".$send_enemy_jutsu."') WHERE `game_status`.`id_ref` = $enemy_id LIMIT 1";

 

Think that would work...

[vegnadragon]

Thanks, man. It worked .