MySQL function library: mysql_error

Mysql_error

(PHP3, PHP4)

Mysql_error---Return an error message from a previous MySQL operation

Syntax: int mysql_error ([int link_identifier])

Description:

Returns the error message code from the last MySQL function, and returns 0 (zero) if no error occurs.

Errors sent back from the MySQL repository can use Mysql_error () to get an error message, Note: This function returns the error message only from the most recently executed MySQL function (not including mysql_error () and Mysql_errno ()), so if you want to use it, Please make sure you have checked the value before calling other MySQL functions.

Example:

<?php

&http://www.aliyun.com/zixun/aggregation/37954.html ">NBSP; Mysql_connect ("Marliesle");

Echo Mysql_errno (). ":". Mysql_error (). <BR> ";

mysql_select_db ("Nonexistentdb");

Echo Mysql_errno (). ":". Mysql_error (). <BR> ";

$conn = mysql_query ("SELECT * from nonexistenttable");

Echo Mysql_errno (). ":". Mysql_error (). <BR> ";

?>

Reference: Mysql_errno ()