MDB_Common::prepareQuery() MDB_Common::queryAll()

MDB

PEAR Manual


MDB_Common::query()

MDB_Common::query() -- send a query to the database

Synopsis

      require_once 'MDB.php';
     

mixed &query ( string $query , array $types )

Description

Executes a SQL query

Parameter

string $query

the SQL query

array $types

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

Return value

mixed - a new a resource id/MDB_OK or a MDB_Error, if fail

Throws

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.

Note

This function can not be called statically.



MDB_Common::prepareQuery() MDB_Common::queryAll()

MDB

PEAR Manual