Description
array mysql_fetch_array
(int result [, int
result_type])
Returns an array that corresponds to the fetched row, or false
if there are no more rows.
mysql_fetch_array() is an extended version of
mysql_fetch_row(). In addition to storing the
data in the numeric indices of the result array, it also stores
the data in associative indices, using the field names as keys.
If two or more columns of the result have the same field names,
the last column will take precedence. To access the other column(s)
of the same name, you must the numeric index of the column or
make an alias for the column.
An important thing to note is that using
mysql_fetch_array() is NOT significantly
slower than using mysql_fetch_row(), while it
provides a significant added value.
The optional second argument result_type
in mysql_fetch_array() is a constant and can
take the following values: MYSQL_ASSOC, MYSQL_NUM, and
MYSQL_BOTH. (This feature was added in PHP 3.0.7)
For further details, see also
mysql_fetch_row().
Example 1. Mysql_fetch_array()
<?php
mysql_connect ($host, $user, $password);
$result = mysql_db_query ("database","select * from table");
while ($row = mysql_fetch_array ($result)) {
echo $row["user_id"];
echo $row["fullname"];
}
mysql_free_result ($result);
?>
|
|