MySQL storing strings

Hello everyone, so I've made a notes system.. and in the notes table, I added "NoteText".
I store the "NoteText" in a variable, but the variable returns "NULL", not the text of the note.

Here's the code:

PHP Code:

forward ViewNotesFunc(playerid);
public ViewNotesFunc(playerid)
{
    new
        rows,
        fields;
    cache_get_data(rows, fields, mysql);
    
    if(rows)
    {
        new string[128], vipnote, noteid, notetext[30];
        for(new i = 0; i < rows; i++)
        {
            noteid = cache_get_row_int(i, 0);
            cache_get_row(i, 4, notetext);
            vipnote = cache_get_row_int(i, 3);
            format(string, sizeof(string), "Note ID: %d || VIP Note: %d || Note text: %s", noteid, vipnote, notetext);
            SendServerMSG(playerid, string);
        }
    }
    else
    {
        SendErrorMSG(playerid, "This player doesn't have any note.");
    }
    return 1;
} 


Let's block ads! (Why?)

MySQL storing strings