Prestashop:更新ps_orders.valid MYSQL

Question

我试图在循环中将ps_orders表中的有效值从0更新为1，但是它一点也不改变，下面是我的代码：

//这是第一个查询：

$query = "SELECT ps_orders.reference,ps_orders.id_order,ps_orders.valid,ps_order_detail.product_name,ps_orders.id_order,ps_orders.date_add,ps_orders.payment,ps_order_detail.unit_price_tax_incl,ps_order_detail.id_order_detail,ps_order_detail.product_quantity,ps_order_detail.product_reference,ps_order_detail.product_weight,ps_order_detail.unit_price_tax_incl,ps_address.id_customer,ps_address.firstname,ps_address.lastname,ps_address.address1,ps_address.address2,ps_address.postcode,ps_address.city
    FROM ps_orders
    JOIN ps_order_detail ON  ps_orders.id_order = ps_order_detail.id_order
    JOIN ps_address ON ps_orders.id_customer = ps_address.id_customer
    WHERE ps_orders.id_order=$i AND ps_orders.valid=1";

//这就是我想要改变值的方式

$uporder = mysql_query("UPDATE ps_orders SET valid=0 WHERE id=".$row[id_order]);

Answer 1

在id表中没有名为ps_orders的列，而是使用id_order列并修改查询如下

"UPDATE ps_orders SET valid=0 WHERE id_order=".$row[id_order