MYSQL loading rows skips first row
#1

Hi,
I'm loading multiple rows:
pawn Код:
new Result:c = sql_query(sql,"SELECT * FROM pastatai WHERE SklypoID = 0",QUERY_CACHED);
    while(sql_next_row(c))
    {
        printf("Object Found, PastatoID = %d",sql_get_field_assoc_int(c,"PastatoID"));
    }
My database:

But the script starts printing from second row, skipping first one. What do I have to do to make it count first row too?
Reply
#2

I suppose sql_next_row jumps to the next row of the retrieved data. If that isn't, which MySQL plugin are you using?
Reply
#3

https://sampforum.blast.hk/showthread.php?tid=429464 This one.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)