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
m (Do not sign your edits) |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 16: | Line 16: | ||
mysql_free_result( c ); | mysql_free_result( c ); | ||
</pre> | </pre> | ||
== Related Functions == | |||
{{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 );