Re: PHP4 MSSQL Error handling
| From: | Doug Durham | Date: | Thu, 25 Jul 2002 00:10:20 +0000 |
| Subject: | Re: PHP4 MSSQL Error handling | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20762@lists.php.net to get a copy of this message | ||
Oops! Sorry all, wrong db.
At 05:05 PM 7/24/2002 -0700, Doug Durham wrote:
$result=mssql_query($sql2)or die("sql2 failed<br>" . mysql_errno() . ": " . mysql_error()); At 04:48 PM 7/24/2002 -0700, Salve Tinkerworth wrote:Does anyone have any good tips for error handling? I've tried different methods to retrieve good error information from mssql_query but nothing seems to be working. Here's the latest attempt: $result=mssql_query($sql2); $result=mssql_query('SELECT @@ERROR As ErrorCode'); $error=mssql_fetch_row($result); if($error['ErrorCode'] != 0) { echo $error['ErrorCode']; echo $sql2; die('Inserting OPS failed'); } -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php