查询某分类下的商品,为什么不正确
2016-07-07 15:05 来源:www.chinab4c.com 作者:ecshop专家
顶顶 顶顶 顶顶 |
回答:
dingdingdingding |
顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶 |
如果只是路径不对,建议查查get_image_path()函数看看 |
如果我将
改为 |
改为
输出 SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, g.promote_price, g.goods_type, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img FROM `ecshop1`.`ecs_goods` AS g LEFT JOIN `ecshop1`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_idIN ('55','77','131','130','129','60','128','59','127','58','92','94','90','91','57','56')OR g.goods_id IN ('') ) limit 10Array ( [] => Array ( [promote_price] => 0 [id] => 492 [goods_style_name] => 124234 [name] => 124234 [brief] => [short_name] => 124234 [market_price] => ¥4410元 [shop_price] => ¥342元 [thumb] => images/200808/thumb_img/492_thumb_G_1219734377814.jpg [goods_img] => images/200808/goods_img/492_G_1219734377995.jpg [url] => goods.php?id=492 [short_style_name] => 124234 ) [1] => Array ( [promote_price] => [id] => 143 [goods_style_name] => 玉兰油1 [name] => 玉兰油1 [brief] => [short_name] => 玉兰油1 [market_price] => ¥0元 [shop_price] => ¥20元 [thumb] => images/200808/thumb_img/143_thumb_G_1219732807166.jpg [goods_img] => images/200808/goods_img/143_G_1219732807465.jpg [url] => goods.php?id=143 [short_style_name] => 玉兰油1 ) ) 晕这是为什么? 是语句错了吗?这是为什么呢? |
顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶 |
最近更新
常用插件
- ecshop2.7.1打印发货单插件
ecshop2.7.1打印发货单插件介绍:ecshop2.7.1和以前的ecshop版本不一样,ecs...
- ecshop商品分类名称增加样
ecshop插件介绍:本插件可以方便在后台管理,为ecshop商品分类名称增加样...
- ecshop二次商品订购人信息
ecshop二次商品订购人信息填写插件,有时候给朋友送花,或者是送礼品的...
- ecshop二次开发详细页面生
插件介绍: ECSHOP系统,在很多时候,很多商品没有人购买,不但购买的人...
- ecshop分类批量扩展插件
ecshop分类批量扩展插件,这个插件是ecshop插件里面比较核心的插件。我们...
ecshop热门问答
ecshop热门资料
ecshop放入回收站
ecshop地址统一
ecshoprul重写
ecshop左下
ecshop奇美优
ecshopcaught
ecshop飞入购物车
ecshop屏幕
ecshop清空数据库
ecshop批量赠送不同类型红包
ecshop遇见
ecshop淘宝接口
ecshop开发网站
ecshop谷模板
ecshop悲剧
ecshop误删public_html
ecshop亮点
ecshop注册帐号
ecshop国庆
ecshopExplorer
ecshop多色模板
ecshop会话
nginx.conf
ecshop商品信息消失
ecshop更多或more
ecshopgreater
ecshop去版权
ecshop订单实时通知
ecshop钱包批发
ecshop路线图