yeah ... then at this point why not to use PHPLIB that has it built in
already...
phplib.netuse.de
a great thing ...
Cheers,
Maxim Maletsky
-----Original Message-----
From: Chris Lee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 1:02 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] need better solution
works for me, just call it. change it to better match yours if you like.
function check_db($query = 'Unavailble')
{
global $store_db;
if ( mysql_errno() )
{
echo "Error: Problem with DataBase : $store_db<br>\n";
echo "Error: " . mysql_errno() . ':' . mysql_error() . "<br>\n";
echo "Query: $query<br>\n";
exit();
}
}
I havent played with a more automatic metod, ie. error_reporting();
--
Chris Lee
Mediawaveonline.com
em. [EMAIL PROTECTED]
ph. 250.377.1095
ph. 250.376.2690
fx. 250.554.1120
""Christian Dechery"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I need a better solution for reporting SQL errors.
I'm used to work with ASP, and whenever a query has a syntax error, it stops
the script and reports the error as if it was a compile error. This is very
usefull, but int PHP it doesn't work like that, I know.
I came with a function query_error() that I call after each query, that
prints out the query, the error and the line... so I need to call it like
this.
if(!$rs) query_error($query,__LINE__);
but having to writ this down after EVERY single query, along with the
__LINE__
thing can get very boring, does anyone has a better solution?
. [ Christian Dechery ]
. Webdeveloper @ Tá Na Mesa!
. Listmaster @ Gaita-L
. http://www.tanamesa.com.br
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
