Description
mixed
mysql_result ( resource result, int row [, mixed field])
mysql_result() returns the contents of one
cell from a MySQL result set. The field argument can be the
field's offset, or the field's name, or the field's table dot
field name (tablename.fieldname). If the column name has been
aliased ('select foo as bar from...'), use the alias instead of
the column name.
When working on large result sets, you should consider using one
of the functions that fetch an entire row (specified below). As
these functions return the contents of multiple cells in one
function call, they're MUCH quicker than
mysql_result(). Also, note that specifying a
numeric offset for the field argument is much quicker than
specifying a fieldname or tablename.fieldname argument.
Calls to mysql_result() should not be mixed
with calls to other functions that deal with the result set.
Example 1. mysql_result() example <?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password")
or die("Could not connect: " . mysql_error());
$result = mysql_query("SELECT name FROM work.employee")
or die("Could not query: . mysql_error());
echo mysql_result($result,2); // outputs third employee's name
mysql_close($link);
?> |
|
Recommended high-performance alternatives :
mysql_fetch_row(),
mysql_fetch_array(),
mysql_fetch_assoc() and
mysql_fetch_object().
