Question

php MySQL 数据调用 循环





若以下回答无法解决问题，邀请你更新回答

Answer 1

while循环和foreach循环在mysql_fetch_array()的用法：
while举例如下：
<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb");
$result = mysql_query("SELECT id, name FROM mytable");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf ("ID: %s Name: %s", $row[0], $row[1]);
}
mysql_free_result($result);
?>
foreach循环举例如下：
$rows = mysql_fetch_all($result);
foreach($rows as $row){
printf ("ID: %s Name: %s", $rows[0], $rows[1]);
}