出现错误: Invalid SQL: select
DISTINCT
P.product_id,
P.class_id,
P.product_code,
P.product_name,
P.delivery_area_id,
P.product_image_two,
P.product_image_four,
P.status,
P.updated_at,
P.orderby,
P.product_oldcode,
PRICE.price_vip,
PRICE.price_member,
PRICE.price_modern
from
pm_product as P,
pm_product_priceplan as PRICE
where
(P.status=72 or P.status=71) and
P.attrib=1 and
P.product_id=PRICE.product_id and
P.tea_type='206'
, updated_at desc,orderby asc LIMIT 0,12
Mysql error description: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' updated_at desc,orderby asc LIMIT 0,12' at line 25
Mysql error number: 1064
Date: 2015-03-17 07:43:02
Script: http://salala.com.cn/productsearch.php