Re: [PHP] mysql_error() problem?

2003-08-14 Thread Curt Zirzow
* Thus wrote Tyler Longren ([EMAIL PROTECTED]): hmmm...perhaps that was it. When I had this issue before, someone told me to check mysql_affected_rows() when using issuing an UPDATE query. I'll give that a shot. Correct, mysql_affected_rows() on a query that doesn't return rows (insert,

Re: [PHP] mysql_error() problem?

2003-08-14 Thread CPT John W. Holmes
From: Tyler Longren [EMAIL PROTECTED] I'm running an UPDATE query on my table. After executing the query, I check mysql_error() to see if there's any errors: if (mysql_error() == ) { // success } else { // failure } mysql_error() is always empty even if the query didn't succeed.

Re: [PHP] mysql_error() problem?

2003-08-14 Thread Tyler Longren
PROTECTED] Sent: Wednesday, August 06, 2003 3:35 PM Subject: Re: [PHP] mysql_error() problem? From: Tyler Longren [EMAIL PROTECTED] I'm running an UPDATE query on my table. After executing the query, I check mysql_error() to see if there's any errors: if (mysql_error

[PHP] mysql_error() problem?

2003-08-07 Thread Tyler Longren
Hi, I'm running an UPDATE query on my table. After executing the query, I check mysql_error() to see if there's any errors: if (mysql_error() == ) { // success } else { // failure } mysql_error() is always empty even if the query didn't succeed. So it always thinks it succeeds. I

[PHP] mysql_error problem

2003-06-23 Thread Ben Edwards
I am using the below function (error_db) witch is called thus:- function query_db( $sql, $db ) { $result = mysql_query( $sql, $db ) or error_db( $sql, $db ); return $result; } But $sqlerr is always blank (it is set with '$sqlerr = mysql_error( $db );'). Any idea why? Ben