<code> $orderQuery = "select sum(`goods`.goods_nums) goods_nums,goods.goods_id,goods.goods_array,goods.product_id,goods.goods_price from iwebshop_order `order` join iwebshop_order_goods `goods` on `order`.id = `goods`.order_id where `order`.status = '5' and unix_timestamp(`order`.create_time) between '".$begin."' and '".$end."' group by `goods`.goods_id"; $njhl = new MYSQL("127.0.0.1","root","","test1"); $orderResult = $njhl->query($orderQuery,'select'); if($orderResult) { foreach($orderResult as $item) { $goodsQuery = "select goods_no,huo_no from goods where id = ".$stock['goods_id']; $goodsResult = $njhl->query($goodsQuery,'select'); if($goodsResult) { foreach($goodsResult as $goods) { $goods_no = trim($goods['goods_no']); $goods_huo = trim($goods['huo_no']); $where; if($goods_no) { $goods_no = strlen($goods_no)query($stockQuery,'select'); var_dump($stockResult); } } } } </code>
查询是有多条数据的!
<code> $orderQuery = "select sum(`goods`.goods_nums) goods_nums,goods.goods_id,goods.goods_array,goods.product_id,goods.goods_price from iwebshop_order `order` join iwebshop_order_goods `goods` on `order`.id = `goods`.order_id where `order`.status = '5' and unix_timestamp(`order`.create_time) between '".$begin."' and '".$end."' group by `goods`.goods_id"; $njhl = new MYSQL("127.0.0.1","root","","test1"); $orderResult = $njhl->query($orderQuery,'select'); if($orderResult) { foreach($orderResult as $item) { $goodsQuery = "select goods_no,huo_no from goods where id = ".$stock['goods_id']; $goodsResult = $njhl->query($goodsQuery,'select'); if($goodsResult) { foreach($goodsResult as $goods) { $goods_no = trim($goods['goods_no']); $goods_huo = trim($goods['huo_no']); $where; if($goods_no) { $goods_no = strlen($goods_no)query($stockQuery,'select'); var_dump($stockResult); } } } } </code>
查询是有多条数据的!