[DJ Data]

Hey, so i'm nearly done with what i wanted to create.. but the mysql is being a bit annoying.

PHP Code:

StartSQL()
{
    SQL_TConnect(DB_Connect, "xxxx");
}

public DB_Connect(Handle:owner, Handle:hndl, const String:error[], any:client)
{
    if (hndl == INVALID_HANDLE)
    {
        LogError("error: %s", error);
        DBConnectionIsRIP = true;
    }
    else
    {
        g_hDB = hndl;
    }
} 

public Action:Command_Alert(client, args)
{
    new String:query[128];
    FormatEx(query, sizeof(query), "SELECT globalAlert FROM Settings");
    SQL_TQuery(g_hDB, alert_callback, query);
}

public alert_callback(Handle:owner, Handle:hndl, const String:error[], any:data)
{
    PrintToChatAll("callback works, but query?!?! You're bad at coding Danian :C");
    
    while(SQL_FetchRow(hndl))
    {
        SQL_FetchString(hndl, 3, alertMessage, sizeof(alertMessage));
        CPrintToChatAll("{red}Arctek ★ Alert: %s", alertMessage);
    }
} 


Database:


This compiles fine, but the server shows this whenever i use it:

[SM] Native "SQL_FetchString" reported: Error fetching data from field 3

Any help is appreciated!

[Powerlord]

"SELECT globalAlert FROM Settings" is only fetching a single field, globalAlert.

[DJ Data]

Originally Posted by Powerlord "SELECT globalAlert FROM Settings" is only fetching a single field, globalAlert.

I tried "SELECT globalAlert FROM Settings WHERE 'index' = 1" and it did nothing.

If i would then remove the FetchRow check, it tells me there is no result. Which is obvious, since we have to call FetchRow first.

So im really at a dead end here.

EDIT:
Ohhhh!!
I just got what you meant!
I'll try it with 0 then.

EDIT 2: Fixed!! Thank you so much <3

[WildCard65]

Originally Posted by DJ Data I tried "SELECT globalAlert FROM Settings WHERE 'index' = 1" and it did nothing. If i would then remove the FetchRow check, it tells me there is no result. Which is obvious, since we have to call FetchRow first. So im really at a dead end here. EDIT: Ohhhh!! I just got what you meant! I'll try it with 0 then. EDIT 2: Fixed!! Thank you so much <3

As far as I'm aware, the results returned are an array who's field at an index match the index it went into the Select statement

[Powerlord]

Yeah, if you have to use a raw database API¹, they're basically all like this for SELECT statements:

1. Execute a SELECT statement.
2. Fetch a row (DB API may do this for you for the first row)
3. Fetch the field(s) you want.
4. Do something with it.
5. Repeat steps 2-4 until you run out of rows.

¹As opposed to an ORM (Object Relational Model) which turns result sets into objects in an OO language.

[Miu]

smlib's sql_fetch*byname functions let you avoid the dum field indices