sqlanywhere_error

Prototype

string sqlanywhere_error( [ resource link_identifier ] )

Returns the error text of the most recently executed SQL Anywhere PHP function. Error messages are stored per connection. If no link_identifier is specified, then sqlanywhere_error returns the last error message where no connection was available. For example, if you call sqlanywhere_connect and the connection fails, then call sqlanywhere_error with no parameter for link_identifier to get the error message. If you want to obtain the corresponding SQL Anywhere error code value, use the sqlanywhere_errorcode function.

This example attempts to select from a table that does not exist. The sqlanywhere_query function returns false and the sqlanywhere_error function returns the error message.

$result = sqlanywhere_query( $conn, "SELECT * FROM table_that_does_not_exist" );
if( ! $result ) {
      $error_msg = sqlanywhere_error( $conn );
      echo "Query failed. Reason: $error_msg";
}