MySQL

I’m requesting an example of a code that will input data into a mysql database using the Gm_MySQL v7 module. I tried, but failed. Thanks in advance.

its like one millon scripts that uses mysql you could just look in one like my admin mod.
straight from it (a serverside concommand).
[LUA]function AddUser(ply, con, args)
checksum = args[3] or “”
if checksum == “fgfdghfgkuilu” then
Pass = args[2] or “”
Pass = crypto.md5(Pass)
Pass = string.lower(Pass)
Uname = args[1] or “”
local db, error2 = mysql.connect(host, username, password, db)
if (db == 0) then print(tostring(error2) … "
“) return end
insert, isok, error = mysql.query(db, “INSERT INTO users (SteamID,Status,Nick,Username,Password,Kills,Deaths,Banmarks) VALUES (’”… ply:SteamID() …”’,0,’"… ply:Nick() …"’,’"… args[1] …"’,’"… Pass …"’,0,0,0)");
if (!isok) then
print(tostring(error) … "
");
Reg(ply)
end
local succ, error = mysql.disconnect(db)
if (not succ) then
print( error );
ply:PrintMessage( HUD_PRINTTALK, “Registration Failed!”);
else
ply:PrintMessage( HUD_PRINTTALK, “You have been registrated on our site!”);
GamewebTitle(ply);
end
end
end
concommand.Add(“adduserdb”, AddUser)[/LUA]