mysql_errno

Synopsis

Returns

Integer on success; FALSE on error

Description

mysql_errno() returns the MySQL error code from the last MySQL function call that invoked a MySQL client routine. If no error occurred, 0 is returned. In many cases, developers will find the mysql_error() function more useful than mysql_errno() , as it returns a human-readable error message. The error codes are quite useful when dealing with sites that support multiple languages, allowing developers to more easily deliver error messages in multiple languages.

There are more than 200 error codes. MySQL provides a series of convenience constants for these codes. You can get a current version by viewing the include/errmsg.h and include/mysqld_error.h files in the MySQL source code distribution (available from http://www.mysql.com).

Version

PHP 3+, PHP 4+

See also

Example

<?php
// Connect to the default MySQL server
// Suppress any error messages with a single at (@) symbol
$mysql_link = @ mysql_connect ();

// If the connection failed, log the error to an error file
if ($mysql_link === FALSE) {
    // Write a terse message to an error log
    error_log (time() . '|' . mysql_errno () . "\n", 3, "mysql_err.log");

    // Redirect the client to a new page to handle the error
    header ("http://www.example.com/error.php?mysql%20connection%20error");
}

// If we made it past here, then we managed to connect
// Continue with the script as normal

echo "Connected to default MySQL server.";
?>