Re: Error codes from 'mysql_error()'
| From: | CC Zona | Date: | Fri, 09 Mar 2001 02:30:12 +0000 |
| Subject: | Re: Error codes from 'mysql_error()' | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-43106@lists.php.net to get a copy of this message | ||
In article <3AA812D9.988FC161@oit.edu>, gearond@OIT.EDU (Dennis Gearon)
wrote:
> I do an insert using phpadmin, and i get back the error message (or
> maybe it's a warning?) The insert is of a duplicate on a unique field. I
> expected an error, but when I do mysql_error() or mysql_errno(), nothing
> comes back(and I do it the next line in the script). the
> 'mysql_query($sql, $link)' function DOES insert when the value is
> unique, DOES return false, but I'd like to inform the user what the
> error was. PHP Admin can get the 'error' why can't I?
Where are the calls placed? mysql_error() or mysql_errno() can only be
used after a valid mysql connection has been established, so for instance
this will not return an error message from mysql:
mysql_connect(stuff) or die(mysql_error());
--
CC