sql.Query

From Garry's Mod
Jump to: navigation, search
 sql.Query( )

Contents

Description

Performs a query on the local SQLite database, returns a table as result set, nil if result is empty and false on error.

Arguments

string query

The query to execute.

Returns

table

false is returned if there is an error, nil if the query returned no data.

Examples

Example

Functions that are examples of saving and creating information into the database.

function CreateTable()
     sql.Query("CREATE TABLE player_data(SteamID TEXT, Money INTEGER)")
end

function NewPlayerToDataBase(ply)
     sql.Query("INSERT INTO player_data(SteamID, Money) VALUES('"..ply:SteamID().."', 0)")
end

function SavePlayerToDatabase(ply, Money)
     sql.Query("UPDATE player_data SET Money="..Money.." WHERE SteamID='"..ply:SteamID().."'")
end


Personal tools
Navigation