PEAR Manual
PrevNext

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

Table 26-1. Possible PEAR_Error values

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

PrevHomeNext
MDB_Common::prepareQuery()UpMDB_Common::queryAll()