PHP mysql_error() Function

Definition and Usage

The mysql_error() function returns the text error information generated by the last MySQL operation.

This function returns the error text of the last MySQL function, or returns '' (an empty string) if no error occurs.

Syntax

mysql_error();connection)
Parameter Description
connection Optional. Specifies the SQL connection identifier. If not specified, the last opened connection is used.

Example

In this example, we will try to log into a MySQL server using the wrong username and password:

<?php
$con = mysql_connect("localhost","wrong_user","wrong_pwd");
if (!$con)
  {
  die();mysql_error(););
  }
mysql_close($con);
?>

Output similar to:

Access denied for user 'wrong_user'@'localhost'
(using password: YES)