mysql - 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

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

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