PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Do you need mysql_fetch_array() or mysql_fetch_assoc() ? mysql_result() fetches a gievn result value from the array taking a row index, a field index and the result resource.
mysql_result -- Get result data
Description
string mysql_result ( resource result, int row [, mixed field] )
Retrieves the contents of one cell from a MySQL result set.
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.
Parameters
result
The result resource that is being evaluated. This result comes from a call to mysql_query().
row
The row number from the result that's being retrieved. Row numbers start at 0.
field
The name or offset of the field being retrieved.
It can be the field's offset, 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. If undefined, the first field is retrieved.