MDB_Common::queryRow() MDB_Common::queryRow() -- fetch the first row
Synopsis
array &queryRow
(string $query, array [$types = NULL MDB_FETCHMODE_DEFAULT NULL
Description
Fetch the first row of data returned from a query. The function takes
care of doing the query and freeing the results when finished.
Parameter
string
$query
the SQL query
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
integer
$rownum
the row number to fetch
Return value
array MDB_Error
Throws
Table 33-1. Possible PEAR_Error values
Error code Error message Reason Solution
MDB_ERROR_NO_DB_SELECTED
NULL
No database was choosen.
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 statment. Ie. using LIMIT in a SQL-Statment
for an Oracle database.
Note This function can not be called
statically.
