Код: Выделить всё
<?phpheader('Content-Type: application/json; charset=utf-8'); $table_name = "fishing"; $viewer_id = '67296096'; $rodBranch = '1'; $rodBambuk = '1'; $db = mysql_connect("localhost","...","...") or die('Connection failed!'); //!! mysql_select_db("fish",$db) or die (mysql_error()); $response['response'] = array('rodBranch' => $rodBranch,'rodBambuk' => $rodBambuk); //Создаю JSON $rods = json_encode($response);//Кодирую $sql = mysql_query("UPDATE $table_name SET rods = $rods WHERE uid = $viewer_id") or die (mysql_error());//Ошибка тут!!! echo "OK";
Код: Выделить всё
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 '"response":{"rodBranch":"1","rodBambuk":"1"}} WHERE uid = 67296096' at line 1
Что не так подскажите, заранее спасибо!)