[Squirrel]

Alright so me again lol

the dialog shows only last thing it found, if I do it all with SendClientMessage it works but dialog shows only last found data

PHP код:

for(new i=0; i < rows; i++) {
        cache_get_field_content(i, "Reason", string);
        format(reason, sizeof(string), string);
        
        cache_get_field_content(i, "Date", dateString);
        format(dateNow, sizeof(dateString), dateString);
        
        format(mainstring,sizeof(mainstring),"%s\t%s\n",string,dateString);
        crimecount++;
    }
    if(crimecount == 0) return Msg(playerid,COLOR_RED,"No results found for this person");
    else if(crimecount >= 1) return ShowPlayerDialog(playerid,DIALOG_PLAYER_CRIMES,DIALOG_STYLE_TABLIST,"Test",mainstring,"Confirm","Decline"); 


[itsCody]

Where are you using this?

[Jefff]

pawn Код:

for(new i=0; i < rows; i++)
{
    cache_get_field_content(i, "Reason", string);
    cache_get_field_content(i, "Date", dateString);

    format(mainstring,sizeof(mainstring),"%s%s\t%s\n",mainstring,string,dateString);
    crimecount++;
}

[Squirrel]

Quote:

Originally Posted by itsCody Where are you using this?

PHP код:

mysql_format(mysql, query, sizeof(query),"SELECT `Name`,`IssuedBy`,`Reason`, `Date` FROM `crimes` WHERE `Name`='%e'",somename);
    mysql_tquery(mysql, query, "OnCrimeLoad","i",playerid); 


PHP код:

forward OnCrimeLoad(playerid);
public OnCrimeLoad(playerid)
{
    new reason[128],
        string[128],
        
        dateNow[128],
        dateString[128],
        rows = cache_num_rows(),
        
        someName[24],
        someStringName[24],
        
        IssuedByOmg[24],
        IssuedByString[24],
        
        crimecount,
        mainstring[1024];
    for(new i=0; i < rows; i++) { 


[itsCody]

Do what Jefff said above.

[Squirrel]

omg Jeff & Code <3 u both! Thanks for the help! THAT WORKED!