How do I get this result from SQL?
#1

This result seems to put 2 results the same, i.e I do one query and it gives me 2 results that are oddly showing it.

QUERY
pawn Код:
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 Код:
for(new x = 0; x < 3; x++)
    {
        if(BSub[playerid][x] == cache_get_row_int(x, 1))
        {
            BSampRes[playerid][x] = 1;
            printf("BSAMP %d", cache_get_row_int(x, 1));//issue area
            printf("BSAMPP %d", BSub[playerid][x]);
        }
        else if(BSampRes[playerid][x] == 0)
        {
            foreach(Player, i)
            {
                if(RecentHospital[i] == 1 && PlayerSQLID[i] == BSub[playerid][i])
                {
                    BSampRes[playerid][x] = 2;
                }
            }
        }
    }
Basically, it puts 2 results although I requested 1.
Reply
#2

Unresolved.
Reply
#3

Still unresolved.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)