Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - mssql_get_last_message() - Retrieving Error Messages
By: FYIcenter.com
(Continued from previous topic...)
How To Retrieve Error Messages using mssql_get_last_message()?
When you call mssql_query() to execute a SQL statement, and the execution
failed on the SQL Server, you can use mssql_get_last_message() function
to retrieve the error messages.
The tutorial script below shows you a good example:
<?php
$con = mssql_connect('LOCALHOST','sa','FYIcenter');
mssql_select_db('FyiCenterData', $con);
# dropping a table
$sql = 'DROP TABLE fyi.center';
$res = mssql_query($sql, $con);
if (!$res) {
print("Execution failed:\n");
print(" Error: ".mssql_get_last_message()."\n");
} else {
print("Execution was successful.\n");
}
mssql_close($con);
?>
If you run this script for the first time, you will get this output:
Execution was successful.
If you run this script again, the SQL statement will fail on the SQL Server,
and you will get:
Warning: mssql_query(): message: Cannot drop the table
'fyi.center', because it does not exist or you do not
have permission. (severity 11) in C:\test\fyi-center.php
on line 7
Execution failed:
Error: Cannot drop the table 'fyi.center', because
it does not exist or you do not have permission.
(Continued on next topic...)
- How To Download and Install PHP on Windows?
- How To Check Your PHP Installation?
- What Do You Need to Connect PHP to SQL Server?
- How to Turn on the MSSQL API Module?
- What Is Wrong with SQL Server Client Libarary DLL, ntwdblib.dll?
- What Happens If ntwdblib.dll Is Missing on Your Machine?
- Where to Find ntwdblib.dll Version 2000.80.194.0?
- How To Connect with Different Port Numbers?
- What Are Commonly Used MSSQL Functions in PHP?
- How To Disconnect from a SQL Server using mssql_close()?
- How To Select an Exiting Database using mssql_select_db()?
- How To Execute a SQL Statement using mssql_query()?
- How To Retrieve Error Messages using mssql_get_last_message()?
- How To Turn Off Warning Messages during PHP Execution?
- How To Receive Returning Result from a Query?
- How To Loop through Result Set Objects using mssql_fetch_array()?
- How To Retrieve Field Values using mssql_result()?
- How To List All Field Names in the Result Set using mssql_field_name()?
|