<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML ><HEAD ><TITLE >mysql_error</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="Manual PHP" HREF="index.html"><LINK REL="UP" TITLE="MySQL Functions" HREF="ref.mysql.html"><LINK REL="PREVIOUS" TITLE="mysql_errno" HREF="function.mysql-errno.html"><LINK REL="NEXT" TITLE="mysql_escape_string" HREF="function.mysql-escape-string.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=ISO-8859-2"></HEAD ><BODY CLASS="refentry" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >Manual PHP</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.mysql-errno.html" ACCESSKEY="P" >Înapoi</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.mysql-escape-string.html" ACCESSKEY="N" >Înainte</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.mysql-error" ></A >mysql_error</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN66926" ></A ><P > (PHP 3, PHP 4 , PHP 5)</P >mysql_error -- Returns the text of the error message from previous MySQL operation </DIV ><DIV CLASS="refsect1" ><A NAME="AEN66929" ></A ><H2 >Description</H2 >string <B CLASS="methodname" >mysql_error</B > ( [resource link_identifier])<BR ></BR ><P > Returns the error text from the last MySQL function, or <VAR CLASS="literal" >''</VAR > (the empty string) if no error occurred. If no link is explicitly passed to the function, the last successful open link will be used to retrieve the error message from the MySQL server. </P ><P > Errors coming back from the MySQL database backend no longer issue warnings. Instead, use <B CLASS="function" >mysql_error()</B > to retrieve the error text. Note that this function only returns the error text from the most recently executed MySQL function (not including <B CLASS="function" >mysql_error()</B > and <A HREF="function.mysql-errno.html" ><B CLASS="function" >mysql_errno()</B ></A >), so if you want to use it, make sure you check the value before calling another MySQL function. <TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="EXAMPLE" ><TR ><TD ><DIV CLASS="example" ><A NAME="AEN66943" ></A ><P ><B >Exemplu 1. <B CLASS="function" >mysql_error()</B > example</B ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><code><font color="#000000"> <font color="#0000BB"><?php<br />$link </font><font color="#007700">= </font><font color="#0000BB">mysql_connect</font><font color="#007700">(</font><font color="#DD0000">"localhost"</font><font color="#007700">, </font><font color="#DD0000">"mysql_user"</font><font color="#007700">, </font><font color="#DD0000">"mysql_password"</font><font color="#007700">);<br /><br /></font><font color="#0000BB">mysql_select_db</font><font color="#007700">(</font><font color="#DD0000">"nonexistentdb"</font><font color="#007700">, </font><font color="#0000BB">$link</font><font color="#007700">);<br />echo </font><font color="#0000BB">mysql_errno</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">) . </font><font color="#DD0000">": " </font><font color="#007700">. </font><font color="#0000BB">mysql_error</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">). </font><font color="#DD0000">"\n"</font><font color="#007700">;<br /><br /></font><font color="#0000BB">mysql_select_db</font><font color="#007700">(</font><font color="#DD0000">"kossu"</font><font color="#007700">, </font><font color="#0000BB">$link</font><font color="#007700">);<br /></font><font color="#0000BB">mysql_query</font><font color="#007700">(</font><font color="#DD0000">"SELECT * FROM nonexistenttable"</font><font color="#007700">, </font><font color="#0000BB">$link</font><font color="#007700">);<br />echo </font><font color="#0000BB">mysql_errno</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">) . </font><font color="#DD0000">": " </font><font color="#007700">. </font><font color="#0000BB">mysql_error</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">) . </font><font color="#DD0000">"\n"</font><font color="#007700">;<br /></font><font color="#0000BB">?></font> </font> </code></TD ></TR ></TABLE ><P > The above example would produce the following output: </P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><PRE CLASS="screen" >1049: Unknown database 'nonexistentdb' 1146: Table 'kossu.nonexistenttable' doesn't exist</PRE ></TD ></TR ></TABLE ></DIV ></TD ></TR ></TABLE > </P ><P > See also <A HREF="function.mysql-errno.html" ><B CLASS="function" >mysql_errno()</B ></A > and <A HREF="http://dev.mysql.com/doc/mysql/en/Error-messages.html" TARGET="_top" >MySQL error messages</A >. </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="function.mysql-errno.html" ACCESSKEY="P" >Înapoi</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Acasã</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.mysql-escape-string.html" ACCESSKEY="N" >Înainte</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >mysql_errno</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.mysql.html" ACCESSKEY="U" >Sus</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >mysql_escape_string</TD ></TR ></TABLE ></DIV ></BODY ></HTML >