This encoded message has been converted to an attachment.>

How about something like this..>

function runquery($query)>{>­ $query = mysql_query($query)­;> if (mysql_error())> {> echo "<div style=\"color:red\"­>MySQL Error: ". mysql_error()>."</d­iv>\n";> exit(1);> }>

return $query;>}>

function runquery($query)AP>­ {AP> $query = mysql_query($query)­;AP> if (mysql_error())AP> {AP> echo "<div style=\"color:red\"­>MySQL Error: ". mysql_error() ."</div>\n";AP> exit(1);AP> }

return $query;AP> }

-----Original Message----- AP> From: Jeff Lewis [mailto:jeff@hyrum.net] AP> Sent: Sat 1/4/2003 6:43 PM AP> To: php-general@lists.p­hp.net AP> Cc: AP> Subject: [PHP] Function to catch all mySQL errors?

I know that mySQL errors are caught in mysql_error() and I find thatAP> function extremely useful (kudos!). However, I have several queries in a fewAP> scripts of mine but am wondering if anyone has written a small function thatAP> catches errors and outputs them. What I mean is lets say I have a block ofAP> code like so:

$result = mysql_query("SELECT­ field1, field2 FROM users WHERE userLogin =AP> '$authusername' AND userPassword = '$authpassword'");

Instead of a small loop under my query that is like so:

if (mysql_error()) {AP> echo "Error: ".mysql_error();AP>­ exit;AP> }

I'd like to be able to call a function that does this instead of adding thisAP> if statement after all my queries...so...anyo­ne do something similar?

Jeff