Scripting/Squirrel/Functions/mysql fetch assoc: Difference between revisions
Jump to navigation
Jump to search
This wiki is using an old backup from 2020
Some information may be old/missing
No edit summary |
No edit summary |
||
| Line 18: | Line 18: | ||
== Related Functions == | == Related Functions == | ||
{{Scripting/Squirrel/Functions/ | {{Scripting/Squirrel/Functions/MySQL Functions}} | ||
[[Category:Scripting/Squirrel/Functions/Mysql_Functions]] | [[Category:Scripting/Squirrel/Functions/Mysql_Functions]] | ||
Latest revision as of 18:28, 30 January 2017
Get a result row as a table
Syntax
mysql_fetch_assoc( MySQLQuery query )
Arguments
- MySQLQuery query - A valid MySQL result
Return value
The row's column as a table
Example
local c = mysql_query( handler, "SELECT Cash, Kills FROM Accounts WHERE Name='KAKAN'" );
local d = mysql_fetch_assoc( c );
print("Cash: " + d["Cash"] + ", Kills: " + d["Kills"] );
mysql_free_result( c );