#41543 [Opn]: Mysql_result doesnt report error code

ID: 41543 User updated by: benjicharlton at gmail dot com Reported By: benjicharlton at gmail dot com Status: Open Bug Type: MySQL related Operating System: WAMP (winxp) PHP Version: 5.2.2 New Comment: err I mean "or Die(mysql_errno()) when refering to my normal or Die commands. Previous Comments: ------------------------------------------------------------------------ [2007-05-30 15:54:44] benjicharlton at gmail dot com Description: ------------ in this example the table called has no entries. Therefore mysql_result ($title,0) should produce an error....which it does however it appears ERROR_NO = 0 and no message is associated. Obviously my work around was to create my own error trap but my normal "OR DIE" is "or DIE(mysql_errno) which doesn't really help anyone debug code failure. Reproduce code: --------------- mysql_select_db($database_db_connect, $db_connect); $query_title ="SELECT MAX(TitleID) FROM title"; $title = mysql_query($query_title, $db_connect) or die(mysql_error()); $id_title = mysql_result($title,0); if (!$id_title){echo "error:";die("<b>A fatal MySQL error occured</b>.\n<br />Query: " . $title . "<br />\nError: (" . mysql_errno() . ") " . mysql_error());} Expected result: ---------------- A fatal MySQL error occured. Query: Resource id #6 Error(#num) Result set contained no rows. Actual result: -------------- A fatal MySQL error occured. Query: Resource id #6 Error(0) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=41543&edit=1