mysql json调用信息重复
$list = $Data->join('w_read ON w_article.id = w_read.aid')->where($where)->order($order)->limit($Page->firstRow.','.$Page->listRows)->select();
调用由于w_read表中aid有重复,导致w_article调出的数据有的重复调用。解决办法:加group by `aid`将调出数据按aid分组
$list = $Data->join('w_read ON w_article.id = w_read.aid')->where($where)->group('aid')->order($order)->limit($Page->firstRow.','.$Page->listRows)->select();
转载请注明出处http://www.cnblogs.com/langxi/,如果该文章对您有所帮助,记得收藏,关注哟!
菩提本无树,明镜亦非台,时时勤拂拭,勿使惹尘埃