MDB_Common::queryRow()

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

Synopsis

       require_once 'MDB.php';

array &queryRow ( string $query , array $types = NULL , integer $fetchmode = MDB_FETCHMODE_DEFAULT , integer $rownum = NULL )

Fetch the first row of data returned from a query. The function takes care of doing the query and freeing the results when finished.

array $types: if supplied, the types of the columns in the result set will be set for fetching

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
MDB_ERROR_NO_DB_SELECTED	NULL	No database was chosen.	Check the DSN in connect() .
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() , queryCol() , queryRow()