while($row=mysql_fetch_array($rs)) 查询总是少第一条数据

Question

include '../config/conn.php';
$sql="select * from goods where goods_promotion_type <> 0";
$rows=$conn->query($sql);
 while($result=mysqli_fetch_array($rows,MYSQL_ASSOC)){
    
            $goods_promotion_type= $result['goods_promotion_type'] ;
            $goods_name = $result['goods_name'];
            $goods_promotion_price = $result['goods_promotion_price'];
            $goods_image = $result['goods_image'];
            $goods_price = $result['goods_price'];
            $goods_jingle = $result['goods_jingle'];
            $evaluation_good_star = $result['evaluation_good_star'];
            $json = array('goods_name' =>$goods_name,
                          'goods_promotion_price' =>$goods_promotion_price, 
                          'goods_image' =>$goods_image,
                          'goods_jingle'=>$goods_jingle,
                          'evaluation_good_star'=>$evaluation_good_star
                    );     
}
这样查询总是从第二条开始，应该怎么修改才能从第一条开始呢？

Answer 1

$json[] = array('goods_name' =>$goods_name,
                          'goods_promotion_price' =>$goods_promotion_price, 
                          'goods_image' =>$goods_image,
                          'goods_jingle'=>$goods_jingle,
                          'evaluation_good_star'=>$evaluation_good_star
                    );