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 <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database 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]

Reply via email to