Scripting/Squirrel/Functions/mysql error: Difference between revisions

From Vice City Multiplayer
Jump to navigation Jump to search
Caution icon
This wiki is using an old backup from 2020
Some information may be old/missing
(Created page with "Returns the last error string of a MySQL connection. == Syntax == <pre>mysql_error( MySQLConnection handler )</pre> == Arguments == * ''MySQLConnection'' '''handler''' - A v...")
 
m (Do not sign your edits)
Line 19: Line 19:
     mysql_free_result( q );
     mysql_free_result( q );
}</pre>
}</pre>
By KAKAN

Revision as of 03:36, 10 March 2016

Returns the last error string of a MySQL connection.

Syntax

mysql_error( MySQLConnection handler )

Arguments

  • MySQLConnection handler - A valid MySQL link/handler

Return value

The last error string. If no errors are there, then it will return an empty string.

Example

function onScriptLoad(){
   local handler = mysql_connect("localhost","root","password","database");
   local q mysql_query(handler,"SELECT FROM table");
   if( mysql_error( handler ) != "" ) //We have a error.
     print( mysql_error( handler ) ); //So printing the error
   else //No errors, let's free the query.
     mysql_free_result( q );
}