mysql phpmyadmin里能执行_Mysql:operator error在phpmyadmin中运行,但在php中不运行

我得到以下信息

select p.*, (select paypal_status from tbl_order as o where paypal_status = 'paid' and end_time > now() and p.post_id = o.post_id) as sort_post from tbl_postad as p where post_category in ('1','7','14','20','26','32','38','44','50','56','62','68','74','80','97','140','144','150','177','179','235','259','284','298','334','370','397','410','429','450','467','479','495','522','535','543') and post_expiredate >= '2018-07-25 13:00:18' and post_delete_status!='Y' and post_cat_status!='N' and block = 0 and post_country = "India" and post_status = 'Y' order by post_date desc LIMIT 0, 15

SQL语法中有错误;请查看手册

对应于MySQL服务器版本,以便使用正确的语法

接近“post_”类别

('1','7','14','20','26','32','38','44','50','56','62','68','74''在

第1行

查询在phpmyadmin中正确执行:

'179','235','259','284','298','334','370','397','410','429'、'450'、'467'、'479'、'495'、'522'、'535'、'543')和post_expiredate>='2018-07-25 13:00:18'和post_delete_状态!“是”和后猫状态!='N'和block=0,post_country=“India”和post_status='Y'按post_date desc LIMIT排序的订单数量限制为0,15

即使是最短的查询也会返回错误:

select p.*, (select paypal_status from tbl_order as o where paypal_status = 'paid' and end_time > now() and p.post_id = o.post_id) as sort_post from tbl_postad as p where post_status='Y' order by post_date desc LIMIT 0, 15

SQL语法中有错误;请查看手册

对应于MySQL服务器版本,以便使用正确的语法

在第1行的“post_status=”Y“附近

我的PHP版本:PHP版本5.6.36

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值