PHP Code:
public void SomeFunction(int Client)
{
if(!IsClientInGame(Client)) return;
char sQuery[1024], userName[64];
GetClientName(Client, userName, sizeof(userName));
g_Database.Escape(userName, userName, sizeof(userName));
Format(sQuery, sizeof(sQuery), "SELECT * FROM test WHERE name='%s';", userName);
g_Database.Query(SQL_SelectTest, sQuery, GetClientUserId(Client));
}
public void SQL_SelectTest(Database db, DBResultSet results, const char[] sError, any data)
{
if(results == null)
{
LogError("MySQL Query Failed: %s", sError);
return;
}
if(!results.FetchRow()) return;
int Client = GetClientOfUserId(data);
if(!IsClientInGame(Client)) return;
int pointsCol;
results.FieldNameToNum("points", pointsCol);
int points = results.FetchInt(idCol);
PrintToChat(Client, "You have %i Points.", points);
}
Obviously you need a valid database connection before doing any of this which you can see how to do here:
https://wiki.alliedmods.net/SQL_(Sou...)#Connecting_2