Question

php 嵌套 循环

$sql = "SELECT * FROM" . $ecs->table('goods')."where cat_id = $cat_id ";
$res = $db->query($sql);
while ($row = $db->fetchRow($res))
{
$sql = "SELECT * FROM" . $ecs->table('goods_attr')."where goods_id = $goods_id";
$res = $db->query($sql);
while ($rowb = $db->fetchRow($res))
{
echo $rowb[attr_value].'---'.$row['goods_id'].'<br>';
}

}

现在输出的是后面的6是可变的,他这个好像是上一个WHILE只循环了一次,就没有了,高手帮我看一下,谢谢

Answer 1

$sql = "SELECT * FROM" . $ecs->table('goods')."where cat_id = $cat_id ";
$res = $db->query($sql);
while ($row = $db->fetchRow($res))
{
$sql = "SELECT * FROM" . $ecs->table('goods_attr')."where goods_id = $goods_id";
$res2 = $db->query($sql);
while ($rowb = $db->fetchRow($res2))
{
echo $rowb["attr_value"].'---'.$row['goods_id'].'<br>';
}

}

你的第一个 $res 的值在循环内被更改了···
应该分开用两个不同的变量