Fetch the first row of data returned from a query. The function takes care of doing the query and freeing the results when finished.
the SQL query
if supplied, the types of the columns in the result set will be set for fetching
the fetch mode to use, default is MDB_FETCHMODE_DEFAULT
the row number to fetch
Table 26-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. |