sql.Query
From GMod Wiki
Revision as of 11:24, 14 August 2010 by DarKSunrise (Talk | contribs)
| Function | |
| Syntax |
sql.Query( String query ) Where is this used? |
| Description: | |
| Queries the SQLite database. | |
| Returns: | Table |
| Part of Library: | Sql |
| Realm: |
 |
| BBCode Link: | [b][url=http://wiki.garrysmod.com/?title=Sql.Query]Sql.Query [img]http://wiki.garrysmod.com/favicon.ico[/img][/url][/b] |
Examples
| Description | This was taken from ratings.lua in sandbox. |
|---|---|
| Used on | |
| Code | /*--------------------------------------------------------- Name: Update the player's networkvars based on the DB ---------------------------------------------------------*/ local function UpdatePlayerRatings( ply ) local result = sql.Query( "SELECT rating, count(*) as cnt FROM ratings WHERE target = "..ply:UniqueID().." GROUP BY rating " ) if ( !result ) then return end for id, row in pairs( result ) do ply:SetNetworkedInt( "Rating."..ValidRatings[ tonumber( row['rating'] ) ], tonumber( row['cnt'] ) ) end end |
| Output | N/A |
Additional Notes
- Returns false if there was an error. You can use sql.LastError to get it.
- Seems to return numbers as strings. (for example: "123", not 123)
