解决当distinct和join同时存在distinct失效问题_PHP教程

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了解决当distinct和join同时存在distinct失效问题_PHP教程，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3780字，纯文字阅读大概需要6分钟。

内容图文

left join pk_ontop as o on o.ontopid=gb.id

left join pk_goods g on gb.goodsid=g.id and g.status=2 and g.invalid>UNIX_TIMESTAMP()

left join pk_fastgroupbuy f on gb.fastgroupbuyid=f.id

where gb.id in ('.$arr_str.') and (gb.status="2" or gb.status="3")

and gb.endtime>UNIX_TIMESTAMP() and gb.starttime<UNIX_TIMESTAMP()

group by onid limit $start,$num";

return TableSystem::query($sql);

变量说明：$arr_str是一个由pk_groupbuy中主键 id组成的一个数组，经过explode函数得到的字符串，

$start,$num分别是查询的开始记录数，和要查询的记录数。

问题说明：pk_ontop表中ontopid在不能记录中有重复现象

比如：我只需要查询出来pk_ontop中当天置顶的ontopid，即商品id，不需要其他的商品信息，查询出来的有ontopid就算有重复现象，这时我可以通过去除数组重复元素解决问题，但是如果我要查询出相应商品id并查询其他相关联表中的信息，并按照ontop表中starttime，status，paixu字段进行排序等操作时，就需要join pk_ontop表，所以之前解决的重复问题就又会出现，无法处理，特别是在api中，是不允许出现重复的，这要怎么办呢？我也不会额，别人教我这样弄，请大家参考下：

$sql = 'SELECT DISTINCT(ontopid),starttime,paixu FROM pk_ontop ORDER BY starttime DESC,STATUS ASC,paixu ASC LIMIT 17';
$arr = TableSystem::query($sql);
foreach($arr as $key=>$val){
$topids[$key] = $val['ontopid'];
}
$arr_str = implode(',',$topids);
$arr1 = TableSystem::query($sql);

$sql = 'select gb.local,f.phone,f.shopname as fshopname,gb.maxnum,gb.intro,gb.buynum,g.pic,f.googleaddress,gb.goodsclassid,gb.sellerid,f.img,gb.province,gb.city,gb.id,gb.title,g.pic,gb.starttime,
gb.endtime,gb.price,gb.goodsprice from pk_groupbuy gb
left join pk_goods g on gb.goodsid=g.id and g.status=2 and g.invalid > UNIX_TIMESTAMP()
left JOIN pk_fastgroupbuy f ON f.id=gb.fastgroupbuyid
where (gb.status="2" or gb.status="3") and gb.endtime > UNIX_TIMESTAMP()
and gb.starttime < UNIX_TIMESTAMP() AND gb.id in ('.$arr_str.')';

$arr2 = TableSystem::query($sql);
foreach($arr2 as $key=>$val){
$local[$val['id']] = $val['local'];
$phone[$val['id']] = $val['phone'];
$fshopname[$val['id']] = $val['fshopname'];
$maxnum[$val['id']] = $val['maxnum'];
$intro[$val['id']] = $val['intro'];
$buynums[$val['id']] = $val['buynum'];
$fgoogleaddresss[$val['id']] = $val['googleaddress'];
$goodsclassid[$val['id']] = $val['goodsclassid'];
$sellids[$val['id']] = $val['sellerid'];
$provices[$val['id']] = $val['province'];
$citys[$val['id']] = $val['city'];
$titles[$val['id']]= $val['title'];
$pics[$val['id']] = $val['pic'] ? $val['pic'] : $val['img'];
$starttimes[$val['id']] = $val['starttime'];
$endtimes[$val['id']] = $val['endtime'];
$prices[$val['id']] = $val['price'];
$goodsprices[$val['id']] = $val['goodsprice'];
}
unset($arr2);
foreach($arr1 as $key=>$val){
$list[$key]['id'] = $val['ontopid'];
$list[$key]['province'] = $provices[$val['ontopid']];
$list[$key]['city'] = $citys[$val['ontopid']];
$list[$key]['title'] = $titles[$val['ontopid']];
$list[$key]['pic'] = $pics[$val['ontopid']];
$list[$key]['starttime'] = $starttimes[$val['ontopid']];
$list[$key]['endtime'] = $endtimes[$val['ontopid']];
$list[$key]['price'] = $prices[$val['ontopid']];
$list[$key]['goodsprice'] = $goodsprices[$val['ontopid']];
$list[$key]['sellerid'] = $sellids[$val['ontopid']];
$list[$key]['fgoogleaddress'] = $fgoogleaddresss[$val['ontopid']];
$list[$key]['goodsclassid'] = $goodsclassid[$val['ontopid']];
$list[$key]['buynum'] = $buynums[$val['ontopid']];
$list[$key]['intro'] = $intro[$val['ontopid']];
$list[$key]['maxnum'] = $maxnum[$val['ontopid']];
$list[$key]['fshopname'] = $fshopname[$val['ontopid']];
$list[$key]['fphone'] = $phone[$val['ontopid']];
$list[$key]['local'] = $local[$val['ontopid']];
}
return $list;

http://www.bkjia.com/PHPjc/630743.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/630743.htmlTechArticle$sql = 'select distinct(ontopid),gb.id as id,f.id as fid,g.id as gid,g.*,gb.*,f.* from pk_groupbuy gb left join pk_ontop as o on o.ontopid=gb.id left join pk_goods g on gb.goodsid=...

内容总结

以上是互联网集市为您收集整理的解决当distinct和join同时存在distinct失效问题_PHP教程全部内容，希望文章能够帮你解决解决当distinct和join同时存在distinct失效问题_PHP教程所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端