   #PHP Manual MySQL Functions mysql_errno mysql_escape_string

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                                  mysql_error

   (PHP 3, PHP 4 )
   mysql_error --  Returns the text of the error message from previous
   MySQL operation

Description

   string mysql_error ( [resource link_identifier])

   Returns the error text from the last MySQL function, or '' (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.

   Errors coming back from the MySQL database backend no longer issue
   warnings. Instead, use mysql_error() to retrieve the error text. Note
   that this function only returns the error text from the most recently
   executed MySQL function (not including mysql_error() and
   mysql_errno()), so if you want to use it, make sure you check the
   value before calling another MySQL function.

   Example 1. mysql_error Example
   <?php
       mysql_connect("localhost", "mysql_user", "mysql_password");
       mysql_select_db("nonexistentdb");
       echo mysql_errno() . ": " . mysql_error(). "\n";
       mysql_select_db("kossu");
       mysql_query("SELECT * FROM nonexistenttable");
       echo mysql_errno() . ": " . mysql_error() . "\n";
   ?>

   The above example would produce the following output:
1049: Unknown database 'nonexistentdb'
1146: Table 'kossu.nonexistenttable' doesn't exist

   See also mysql_errno().
   ______________________________________________________________________

   Prev        Home                Next
   mysql_errno  Up  mysql_escape_string
