我原来都是用while or do...while来循环,没有用过foreach,请帮忙下面的用foreach该怎么写
$sql="select * from friendLink";
$res=mysql_query($sql);
while ($rs=mysql_fetch_array($res)){
{
echo "Value: " .$rs["id"]. $rs["title"] . "<br />";
}
//该怎么写循环
foreach ($rs as $value)
{
echo "Value: " . $value . "<br />";
}
$sql="select * from friendLink";
$res=mysql_query($sql);
while ($rs=mysql_fetch_array($res)){
{
echo "Value: " .$rs["id"]. $rs["title"] . "<br />";
}
//该怎么写循环
foreach ($rs as $value)
{
echo "Value: " . $value . "<br />";
}
{
echo "Value: " . $value . "<br />";
} 这个里面的rs是数组. 所以循环不了.查数据库还是用while好..
$sql = "select id,name from friendLink";
$res = mysql_query($sql);
$rs = mysql_fetch_assoc($res);
foreach ($rs as $value)
{
echo "Value: " . $value['name'] . "<br />";
}
?>
后 $res 是资源forecho 的源,应该数组或对象所以不能用 foreach 遍历查询结果