Re: how to get ERROR message
| From: | Dobromir Velev | Date: | Fri, 06 Jul 2001 07:21:39 +0000 |
| Subject: | Re: how to get ERROR message | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10113@lists.php.net to get a copy of this message | ||
Hi,
dud you try to use something like this
$result=mssql_query("exec xxxxx") or die(mssql_get_last_message());
instead of
$result=mssql_query("exec xxxxx") or die("query failed");
Removing the "or die" part must display an error message too, but it won't
end the script execution.
Dobromir Velev
-----Original Message-----
From: jong jong <jxu158@yahoo.com>
To: php-db@lists.php.net <php-db@lists.php.net>
Date: Thursday, July 05, 2001 7:38 PM
Subject: [PHP-DB] how to get ERROR message
>Hi,
>
>How can I see the error message from browser? My code
>is like this:
><html><body>
><?
>$conn=mssql_connect("xxx","xxxx","xxxxxxxx");
>mssql_select_db("xxx",$conn);
>$result=mssql_query("exec xxxxx") or die("query
>failed");
>mssql_free_result($result);
>?>
></body></html>
>
>I got "query failed" on the browser screen and nothing
>else. Here is some value I got from phpinfo():
> Configuration
> PHP Core
> Directive Local value Master value
>display_errors On On
>display_startup_errors
> Off Off
>doc_root no value no value
>enable_dl On On
>error_append_string Off Off
>error_log no value no value
>error_prepend_string
> Off Off
>error_reporting 2039 2039
>
>Are they enough to display the error messages?
>Please help! I really do need to trace the errors.
>
>Thanks,
>jongjong
>
>__________________________________________________
>Do You Yahoo!?
>Get personalized email addresses from Yahoo! Mail
>http://personal.mail.yahoo.com/
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
>For additional commands, e-mail: php-db-help@lists.php.net
>To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>