Scripting/Squirrel/Functions/mysql fetch row: 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 "Get a result row as an enumerated array. == Syntax == <pre>mysql_fetch_row( query );</pre> == Arguments == * '''query''' - Name of the previously executed query. == Exam...")
 
No edit summary
Line 19: Line 19:
ClientMessage( "Your stats - Kills: "+stats[0]+", Deaths: "+stats[1]+".",255,255,255);
ClientMessage( "Your stats - Kills: "+stats[0]+", Deaths: "+stats[1]+".",255,255,255);
}</source>
}</source>
=== Notes ===

Revision as of 11:11, 28 September 2015

Get a result row as an enumerated array.

Syntax

mysql_fetch_row( query );

Arguments

  • query - Name of the previously executed query.

Example

function onPlayerCommand(player, cmd, parameters)
{
if (cmd == "stats")
{
local query = mysql_query(vcmpdb, "SELECT kills, deaths FROM accounts WHERE name = '"+player.Name+"'");
local stats = mysql_fetch_row(query);
ClientMessage( "Your stats - Kills: "+stats[0]+", Deaths: "+stats[1]+".",255,255,255);
}