MDB_Common::fetchRow()

MDB_Common::fetchRow() -- fetch the first row

Synopsis

       require_once 'MDB.php';

array &fetchRow ( resource $result , integer $fetchmode = MDB_FETCHMODE_DEFAULT , integer $rownum = NULL )

Fetch the first row of data returned from a result set and free the result set.

resource $result: a valid resource returned by query() or executeQuery()

integer $fetchmode: the fetch mode to use, default is MDB_FETCHMODE_DEFAULT

array - the first row of results as an array indexed from 0 or a MDB_Error, if fail

Possible PEAR_Error values

Error code	Error message	Reason	Solution
every other error code		Database specific error	Check the database related section of PHP-Manual to detect the reason for this error. In the most cases a misformed SQL statement. Ie. using LIMIT in a SQL-Statement for an Oracle database.

This function can not be called statically.

query() , limitQuery() , prepareQuery() executeQuery() , fetchCol() , fetchRow()