[ Menü ]

[ Inhalt ]

Hits gesamt: 5197583
Hits Heute: 622
max. Hits (10.07.07): 6964
User Online: 32
Scripts: 2828

Kompakt im Doppelpack: HTML und JavaScript. Webdesign für Einsteiger

PEAR Manual
Prev		Next

DB_Common::getRow() -- fetch the first row

array &getRow (string $query [, array $params = array() [, integer $fetchmode = DB_FETCHMODE_DEFAULT]])

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

string $query: the SQL query
array $params: if supplied, prepare()/ execute() will be used with this array as execute parameters
integer $fetchmode: the fetch mode to use, default is DB_FETCHMODE_DEFAULT

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

Table 20-1. Possible PEAR_Error values

Error code	Error message	Reason	Solution
`DB_ERROR_INVALID`	`NULL`	SQL statment for preparing is not valid.	See the prepare() documentation, if you want to use a SQL statemt using wildcards.
`DB_ERROR_NEED_MORE_DATA`	`NULL`	To less data for filling the prepared SQL statment.	Check the number of wild cards given in the SQL statment prepare(). Check the count of entries in the array for `$params`. The count of entries have to be equal to the number of wild cards.
`DB_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.

This function can not be called statically.

query() , limitQuery() , prepare() execute() , getCol() , getRow() , getAssoc()

Prev	Home	Next
DB_Common::getOne()	Up	DB_Common::limitQuery()