Scripting/Squirrel/Functions/mysql query

This function will execute a query from the MySQL database.

Syntax

mysql_query( database, query);

Arguments

• database - The database on which the query shall be executed.
• query - The query to be executed.

Example

function onPlayerCommand(player, command, arguments)
{
if (command=="resetcash")
{
mysql_query( vcmpdb, "UPDATE accounts SET cash = '0' WHERE name = '"+player.Name+"'");
}
}

Notes

You can also use this function to SELECT, DELETE, INSERT etc.

Related Functions

• mysql_affected_rows
• mysql_change_user
• mysql_close
• mysql_connect
• mysql_errno
• mysql_error
• mysql_escape_string
• mysql_fetch_assoc
• mysql_fetch_lengths
• mysql_fetch_row
• mysql_free_result
• mysql_info
• mysql_insert_id
• mysql_num_fields
• mysql_num_rows
• mysql_ping
• mysql_query
• mysql_select_db
• mysql_warning_count