php - 更新mysql错误

Question

我有这些代码行:

$sql = mysql_query("UPDATE user SET txnid='" . mysql_real_escape_string($data['txn_id']) . "',
  payment_amount='" . mysql_real_escape_string($data['payment_amount']) . "' ,
  payment_status='" . mysql_real_escape_string($data['payment_status']) . "',
  itemid='" . mysql_real_escape_string($data['item_number']) . "',
  createdtime='" . mysql_real_escape_string(date("Y-m-d H:i:s")) . "' WHERE id='" . mysql_real_escape_string($_COOKIE["buy_user"]) . "'";

  $result = mysql_query($sql);

我正在尝试更新 ID 117。

我知道我必须使用 UPDATE，但我做不到。

帮帮我

Answer 1

奇怪的是，您调用了 mysql_query 函数两次。

我建议您遵循以下模式:

 # set a variable to contain just a string, the SQL text you want to execute
 $sql = "UPDATE ... ";

 # the SQL text is conveniently available for debugging/logging
 echo $sql;

 # execute the SQL
 $result = mysql_query($sql);