[Squirrel]

Alright so Im trying to load everything from the SQL but it loads only first 2 rows & ID is incorrect

PHP код:

new query[256];
    mysql_format(mysql, query, sizeof(query),"SELECT `Reason`,`Date`,`By`,`ID` FROM `bolo`");
    mysql_tquery(mysql, query, "OnBoloLoad","i",playerid); 


EDIT: What im trying to basically do is to load the entire table.

[itsCody]

PHP код:

mysql_tquery(mysql, "SELECT * FROM `bolo`", "OnBoloLoad", "i", playerid); 


Try that.

[Squirrel]

Still nothing :/

this is my displaying

PHP код:

for(new i=0; i < rows; i++) {
        cache_get_field_content(i, "Reason", someStringName);
        cache_get_field_content(i, "Date", IssuedByString);
        cache_get_field_content(i, "By", string);
        cache_get_field_content(i, "ID", dateString);
        format(mainstring,sizeof(mainstring),"{00FFFF}Text: {FFFFFF}%s || {00FFFF}Date: {FFFFFF}%s || {00FFFF}By: {FFFFFF}%s || {00FFFF}ID: {FFFFFF}%i",someStringName,IssuedByString,string,dateString);
        Msg(playerid,-1,mainstring);
        crimecount++;
    } 


[itsCody]

Post the full callback

[Squirrel]

Nevermind.. I failed somewhere else....

Thanks for the help tho :*