// 本类由系统自动生成,仅供测试用途
Class IndexAction extends Action {
Public function index(){
$v_list = M('ngoods')->order('id DESC')->select();
foreach ($v_list as $v){
$str=explode(",",$v['goodsno']);
$goodsno=array_values(array_diff($str, array('')));
foreach ($goodsno as $vv ){
$M_gd_goods = M("gd_goods");
$condition['gd_goods.goodsno'] = array('eq',$vv);
$info_list = $M_gd_goods->field("gd_goods_option.price,gd_goods.goodsnm,gd_goods.goodsno,gd_goods.img_s,gd_goods_brand.brandnm")->join('gd_goods_option ON gd_goods.goodsno = gd_goods_option.goodsno')->join('gd_goods_brand ON gd_goods.brandno = gd_goods_brand.sno')->where($condition)->find();
if($condition['gd_goods.goodsno']){
$a_list[] = array(
'price'=>$info_list['price'],
'goodsnm'=>$info_list['goodsnm'],
'img_s'=>$info_list['img_s'],
'brandnm'=>$info_list['brandnm'],
'goodsno'=>$info_list['goodsno'],
);
}
//$a_list[] = array(
// 'price'=>$info_list['price'],
// 'goodsnm'=>$info_list['goodsnm'],
// 'img_s'=>$info_list['img_s'],
// 'brandnm'=>$info_list['brandnm'],
// 'goodsno'=>$info_list['goodsno'],
// );
}
$b_list[] = array(
'id'=>$v['id'],
'ti
'content'=>$v['content'],
'time'=>$v['time'],
'good_list'=>$a_list,
);
dump($condition);
}
$this->assign('ngoods', $b_list)->display('List');
}
}
?>
上面是关联查询,显示的代码.....
goodsno,数据是用,号分割的,显示有问题怎么办啊?哎
最佳答案