(PHP 4 >= 4.0.3)
mysql_fetch_assoc -- Fetch a result row as an associative array
Description
array mysql_fetch_assoc (resource result)
Returns an associative array that corresponds to the fetched row, or FALSE
if there are no more rows.
mysql_fetch_assoc() is equivalent to calling mysql_fetch_array() with MYSQL_ASSOC for the optional
second parameter. It only returns an associative array. This is the way mysql_fetch_array() originally worked. If you need the
numeric indices as well as the associative, use
mysql_fetch_array().
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 either need to access the result
with numeric indices by using mysql_fetch_row()
or add alias names. See the example at the
mysql_fetch_array() description about aliases.
An important thing to note is that using mysql_fetch_assoc() is not
significantly slower than using
mysql_fetch_row(), while it provides a significant added value.
For further details, see also
mysql_fetch_row() and
mysql_fetch_array().
|
Example 1. mysql_fetch_assoc()
<?php
mysql_connect($host, $user, $password);
mysql_select_db($database);
$query = "select * from table";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo $row["user_id"];
echo $row["fullname"];
}
mysql_free_result($result);
?>
|
|
|
