Definition and Usage
定义和用法

The mysql_fetch_row() function returns a row from a recordset as a numeric array.
mysql_fetch_row()函数的作用是：从结果集中取得一行作为数值型数组。

This function gets a row from the mysql_query() function and returns an array on success, or FALSE on failure or when there are no more rows.
如果函数成功执行，它将获取一行信息（该行是通过执行mysql_query()函数取得的）并返回该行信息；如果失败，将不返回任何一行。

Syntax
语法

mysql_fetch_row(data)

Tips and Notes
注意点

Note: After the data is retrieved, this function moves to the next row in the recordset. Each subsequent call to mysql_fetch_assoc() returns the next row in the recordset.
注意：获取数据之后，mysql_fetch_row()函数将移动到下一条记录；如果函数成功执行，它将获取一行信息（该行是通过执行mysql_query()函数取得的）并返回该行信息

Example
案例

<?php
$con = mysql_connect("localhost", "peter", "abc123");
if (!$con) { die('Could not connect: ' . mysql_error()); }

$db_selected = mysql_select_db("test_db",$con);
$sql = "SELECT * from Person WHERE Lastname='Refsnes'";
$result = mysql_query($sql,$con);
print_r(mysql_fetch_row($result));

mysql_close($con);
?>

The output of the code above could be:
上述代码将输出下面的结果：

Array
(
[0] => Refsnes
[1] => Kai Jim
[2] => Taugata 2
[3] => 22
) 

评论 (0) All