previousMDB_Common::prepareQuery() (Previous) (Next) MDB_Common::queryAll()next

View this page in Last updated: Sun, 18 Oct 2009
English | Brazilian Portuguese | Chinese | Dutch | French | German | Hungarian | Japanese | Polish | Russian | Spanish | Turkish

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.

previousMDB_Common::prepareQuery() (Previous) (Next) MDB_Common::queryAll()next

Download Documentation Last updated: Sun, 18 Oct 2009
Do you think that something on this page is wrong? Please file a bug report or add a note.
User Notes:
There are no user contributed notes for this page.