Error Messages into Variable

[stig1]

I would like to put error messages from mysql or my odbc connection into variables to which later I will email them out (already know how to use mail, so no help needed there)

 

How would I put the following into a variable called $error should the sql fail in anyway.

 

$iItemSQL = "insert into items (item, type1, type2, desc1, createdate, lastupdate) values ('".$item."', '".$type1."', '".$type2."', '".$desc1.'", '".$createdate."', '".$lastupdate."')";

$iItems = mysql_query($iItemSQL) or die (mysql_error());

 

Running the above script, if it was to fail would just die and display the error on the screen.

 

Instead of just die and display error, I would like the script to put that error message into a variable to which i can later call, and the script can continue to run.

 

Would this possible work?

 

if(!$iItems){

$error = Error: '.mysql_errno().' '.mysql_error();

}

 

Help is always apprecaited and a huge thankyou in advance.

[Yesideez]

if (mysql_query($query)) {
  echo 'It worked';
} else {
  echo 'It failed!';
  $error=mysql_error();
}

[JasonLewis]

You can also just do:

 

mysql_query("SELECT * FROM table") or $error = mysql_error();

 

Of course you could jazz it up a bit.

[stig1]

I plan to jazz it up abit, but i just had no idea how to get it into a variable. Once its in a variable I can add text, and etc to make it more user friendly.

 

Would my suggested answer work?

[Yesideez]

The "or die" bit would kick in if the query failed so you'd have to remove that but other than that - yes, it should work.