TIPS: MySQL Query Error
SQL:SELECT c.area_id,c.pinpai_id, c.pinpai_name,c.pinpai_ename,c.pinpai_zmc,c.pinpai_year,c.pinpai_pic,c.pinpai_jianjie,c.pinpai_tmall,c.pinpai_sellerID,c.pinpai_jd,c.pinpai_jdzy,a.paihang_id,a.paihang_order,a.cate_id FROM brand_pinpai_paihang a LEFT JOIN brand_pinpai c ON a.pinpai_id=c.pinpai_id where a.cate_id= and c.pinpai_status=3 ORDER BY a.paihang_order ASC LIMIT 0, 100
Error: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 'and c.pinpai_status=3 ORDER BY a.paihang_order ASC LIMIT 0, 100' at line 1
Errno:1064