RE: [PHP] Function to catch all mySQL errors?

2003-01-04 Thread Adam Plocher 
How about something like this..
 
function runquery($query)
{
 $query = mysql_query($query);
 if (mysql_error())
 {
 echo div style=\color:red\MySQL Error: . mysql_error() ./div\n;
 exit(1);
 }
 
return $query;
}
 

-Original Message- 
From: Jeff Lewis [mailto:[EMAIL PROTECTED]] 
Sent: Sat 1/4/2003 6:43 PM 
To: [EMAIL PROTECTED] 
Cc: 
Subject: [PHP] Function to catch all mySQL errors?



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

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

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

if (mysql_error()) {
 echo Error: .mysql_error();
 exit;
}

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

Jeff



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Function to catch all mySQL errors?

2003-01-04 Thread Michael J. Pawlowsky 
Also if you dont want ot to break you need to add the @ operator in front


Mike


*** REPLY SEPARATOR  ***

On 04/01/2003 at 6:47 PM Adam Plocher wrote:

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()
./div\n;
 exit(1);
 }
 
return $query;
}
 



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php