php - 获取一个字段中的所有行数据

Question

$stmt = $db->query("SELECT c.id, c.name FROM (SELECT @r AS _id, (SELECT @r := parent FROM categories WHERE id = _id) AS parent, @l := @l + 1 AS lvl FROM (SELECT @r := 74, @l := 0) vars, categories m WHERE @r <> 0) m JOIN categories c ON m._id = c.id ORDER BY m.lvl DESC;");           
                    while($bread = $stmt->fetch()){                         
                        $plip = $bread['name'];
                        $each = "$plip-";
                        echo $each;
                        echo "<label value='$each'></label>";                                   

                    }

echo $each得到这个输出:“Milk-Cat-Cookie”，这就是我想要的，所以它很好。

但是回显<label value='$each'></label>给出此输出:<label value='Milk-'></label>

但它必须是这样的:<label value='Milk-Cat-Cookie'></label>

那么为什么我不能在一个字段中显示所有行数据呢？

Answer 1

尝试输入 echo <label value='$each'></label>;划出“while”语法，像这样:

while($bread = $stmt->fetch()){                         
    $plip = $bread['name'];
    $each = "$plip-";
    echo $each;
}
echo "<label value='$each'></label>"; 

请注意，我对 $each 上的结果的每次迭代都进行了连接变量。