关于foreach输出有关问题

$sql1="select * from y_cate order by asc";
$result1=mysql_fetch_array(mysql_query($sql1));
var_dump($result1);
foreach($result1 as $ke=>$a){
echo $a."
";
}
?>
我想用foreach 来循环输出cate表的所有数据，为什么只输出一条数据的？求解答

Quote: 引用:

$sql1="select * from y_cate order by asc";<br />
$result1 = mysql_query($sql1);<br />
while($row = mysql_fetch_array($result1)) {<br />
  foreach($row as $ke=>$a){<br />
    echo $a."<br>";<br />
  }<br />
}

Copy after login

Copy after login

必须要用while么？
如果用while的话
[code]  $sql1="select * from y_cate order by px asc";
                                $us=mysql_query($sql1);
                                while($result1=mysql_fetch_array($us)){