Question

ecshop二次开发 购物车添加商品限制如果购物车里有1元商品则不能继续添加购物车

$sql_where111 = $_SESSION['user_id']>0 ? "user_id='". $_SESSION['user_id'] ."' " : "session_id = '" . SESS_ID . "' AND user_id=0 ";
$sql111 = mysql_query("SELECT COUNT(*) FROM " . $ecs->table('cart') ." WHERE $sql_where111 " ." AND goods_price =1");
$sql123 = mysql_fetch_array($sql111);
if (!empty$sql123) {
$result['error'] = 888;
$result['message'] = "特价商品每次限购一单！";
die($json->encode($result));
}
我写的代码 运行出错，无论有没有一元商品都提示不能购买。菜鸟新手，大神误笑啊

Answer 1

知会sql语句

if exists (select 1 from tablename where goods_price =1)then
select '特价商品每次限购一单'
else
select '可以添加';

end if