Question

帮我看看这段php为何取出的值只有一行，while ($row = $GLOBALS['db']->fetch_array($query))无法理解

我需要显示5行，可是只能显示一行，谢过了
include_once('includes/cls_json.php');
$json = new JSON;
$result = '';
if (!empty($_COOKIE['ECS']['history']))
{
$where = db_create_in($_COOKIE['ECS']['history'], 'goods_id');
$sql = 'SELECT goods_id, goods_name, goods_thumb, shop_price FROM ' . $GLOBALS['ecs']->table('goods') .
" WHERE $where AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0";
$query = $GLOBALS['db']->query($sql);
$result = array();
while ($row = $GLOBALS['db']->fetch_array($query))

{
$goods['goods_id'] = $row['goods_id'];
$goods['goods_name'] = $row['goods_name'];
$goods['short_name'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ? sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
$goods['goods_thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);
$goods['shop_price'] = price_format($row['shop_price']);
$goods['url'] = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']);
$result['his'] ='<ul class="clearfix"><li class="goodsimg"><a href="'.$goods['url'].'" target="_blank"><img src="'.$goods['goods_thumb'].'" alt="'.$goods['goods_name'].'" class="B_blue" /></a></li><li><a href="'.$goods['url'].'" target="_blank" title="'.$goods['goods_name'].'">'.$goods['short_name'].'</a><br />'.$GLOBALS['_LANG']['shop_price'].'<font class="f1">'.$goods['shop_price'].'</font><br /></li></ul>';

}

}
die($json->encode($result));

Answer 1

从数据库查询后的集合中读取一行数据到 变量 $row 中指差戚，如果已经庆旁到了最后（也就是没有数据了）将返回 false，循环结束

例如：
$r=mysql_query("select * from comment_tmp ");

while($tmp=mysql_fetch_assoc($r))
{
// 循环处理查询出的结果

}

只能显示一行：
应唯陵该是最后一行，因为前面的数据都被覆盖了
$result['his'] =

改成
$result['his'] .=
将结果累加就好了

Answer 2

把正斗fetch_array改成搏唯fetch_row。举银磨

追问

这个我改过不行，你楼上的方法可行