Error: Unknown column 'a.nid' in 'ORDER BY' SELECT a.nid, b.goods_nid, a.now_state,a.model_name, a.buyer_id, a.buyer_name,
a.total_price, b.bank_name,b.bank_num,b.bank_owner,b.pay_date FROM tb_buy_info a, tb_return b WHERE ( a.nid = b.buyinfo_nid AND a.now_state =13 AND a.buyer_id = '' AND pay_date > SUBDATE(NOW(),INTERVAL 7 DAY))
union all SELECT a.nid, c.goods_nid, a.now_state,a.model_name, a.buyer_id, a.buyer_name,
a.total_payment, c.bank_name, c.bank_num, c.bank_owner,c.pay_date FROM tb_buy_info a, tb_sale_finish c WHERE ( a.nid = c.buyinfo_nid AND a.now_state =12 AND a.seller_id = '' AND pay_date > SUBDATE(NOW(),INTERVAL 7 DAY)) ORDER by a.nid limit 0, 15
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/bogoshop/public_html/include/db.inc on line 145
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/bogoshop/public_html/include/db.inc on line 150
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/bogoshop/public_html/include/db.inc on line 135 ¼ºñ½º1µî °¡°Ý1µî 47 ˜Þ