JavaScript Editor Javascript validator     Web page editor 


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


require_once 'MDB.php';

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


Executes a SQL query


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


Table 39-1. Possible PEAR_Error values

Error codeError messageReasonSolution
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.

JavaScript Editor Javascript validator     Web page editor