[Dokins]

I feel that the IN operator is causing havoc. Essentially, I'm checking to see if 3 ID's (3 sample slots) exist but it only returns 1 result and I am having great difficulty, any assistance would be appreciated.

BSub is definitely getting submitted.

pawn Code:

new query[256];
format(query, sizeof(query), "SELECT * FROM `arecords` WHERE PSQLID IN(%d, %d, %d)", BSub[playerid][0], BSub[playerid][1], BSub[playerid][2]);
mysql_tquery(dbHandle, query, "GetBloodResult", "i",playerid);

pawn Code:

for(new x = 0; x < 3; x++)
    {
        if(BSub[playerid][x] == cache_get_row_int(x, 1) )
        {
            BSampRes[playerid][x] = 1;
            printf("Sub 0 called");
            printf("RESULT FROM THE ROW %d", cache_get_row_int(x, 1));
        }
    }