$query = "select id, name from MyTable order by name"; $result = mysql_query($query); while (list($id, $name) = mysql_fetch_row($result)) { echo("Name: $name ($id) <br />"); }
函数从result_set中获取整个数据行，将值放在一个索引数组中。通常会结使list()函数使用
获取和显示数据
mysql_fetch_array()
array mysql_fetch_array (resource result_set [, int result_type]) $query = "select id, name from MyTable order by name"; $result = mysql_query($query); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $id = $row["id"]; $name = $row["name"]; echo "Name: $name ($id) <br />"; }
