php - MYSQL 数据库列未更新

Question

请大家帮忙，我需要你们帮助更新 mysql 数据库。下面是代码:

$sql_1 = "UPDATE tbl_courier
          SET status = '$status', 
              comments = '$comments', 
              aarrival = '$aarrival', 
              transferdate = '$transferdate', 
              bl = '$bl', 
              `containerno` = '$containerno', 
              eta = '$eta', 
              rev_name = '$Receivername'
           WHERE cid = $cid
              AND cons_no = '$cons_no'";

  dbQuery($sql_1);

除了containerno、eta和rev_name之外，每一列都使用新输入进行更新

我做错了什么，请帮忙...

Answer 1

据我所知，有一行不合适。更改此:

$sql_1 = "UPDATE tbl_courier
          SET status = '$status', 
              comments = '$comments', 
              aarrival = '$aarrival', 
              transferdate = '$transferdate', 
              bl = '$bl', 
              `containerno` = '$containerno', 
              eta = '$eta', 
              rev_name = '$Receivername'
           WHERE cid = $cid
              AND cons_no = '$cons_no'";

  dbQuery($sql_1);

对此:

$sql_1 = "UPDATE tbl_courier
          SET status = '$status', 
              comments = '$comments', 
              aarrival = '$aarrival', 
              transferdate = '$transferdate', 
              bl = '$bl', 
              containerno = '$containerno', 
              eta = '$eta', 
              rev_name = '$Receivername'
           WHERE cid = $cid
              AND cons_no = '$cons_no'";

  dbQuery($sql_1);

这里是这一行:

`containerno` = '$containerno',

我相信您不需要列之前和之后的代字号。

旧行:

`containerno` = '$containerno',

新行:

containerno = '$containerno',

当您添加波浪号时，如您所见。它导致其余语法无效。