Error Message Help

[jmfillman]

I'm using the following function to return data to Adobe Flex:

 

  public function cancelUpdate($id, $cancelDate) {

$date5 = date("Y-m-d H:i:s", $canceldate);

$query = "UPDATE apData SET status=1, cancelDate='$date5' WHERE id='$id'";

$result = mysql_query($query);

$msg=$this->err_prefix."INSERT query error: ".$this->mysql->error;

throw new Exception($msg);

return true;

  }

 

The problem I am encountering is that even when the update query is successful, PHP is returning "INSERT query error: ". What am I doing wrong?

[Tchelo]

Well, it seems to me that you are always throwing the exception. There is not a check to see if the query has been correctly executed.

[cooldude832]

The most common convention for query error reporting is

<?php
   public function cancelUpdate($id, $cancelDate) {
   $date5 = date("Y-m-d H:i:s", $canceldate);
   $query = "UPDATE apData SET status=1, cancelDate='$date5' WHERE id='$id'";
   $result = mysql_query($query) or die(mysql_error()."<br /><br />\n\n".$query);
         $msg=$this->err_prefix."INSERT query error: ".$this->mysql->error;
         throw new Exception($msg);
   return true;
   }
?>

if you want to integrate a "throw exception" into it you need to say

<?php
   public function cancelUpdate($id, $cancelDate) {
   $date5 = date("Y-m-d H:i:s", $canceldate);
   $query = "UPDATE apData SET status=1, cancelDate='$date5' WHERE id='$id'";
   $result = mysql_query($query) or die(mysql_error()."<br /><br />\n\n".$query);
   if(!$result){
         $msg=$this->err_prefix."INSERT query error: ".$this->mysql->error;
         throw new Exception($msg);
  }
else{
   return true;
}
   }

[jmfillman]

Thank you!