database->getErrorNum

Returns the most recent database error code.  See also database->stderr.

Syntax

integer getErrorNum ( )

Examples

Example:

$query = "SELECT * FROM 'bad_table'";
$database->setQuery( $query );
$rows = $database->loadObjectList();
if ($database->getErrorNum()) {
  echo 'Error ' . $database->getErrorNum() . ': ' . $database->getErrorMsg();
}

which would output:

Error 1064: You have an error in your SQL syntax near \'\'bad_table\'\'
        at line 1 SQL=SELECT * FROM \'bad_table\'
 

Please report any errors on this page to the Developer Documentation Forum.