[Shidony]

Hi everybody !

I want to create a multi-character system in one account so i want to list all the characters linked with the account in a dialog.

I have this query:

pawn Код:

format(sql,sizeof(sql),"SELECT Name FROM characters WHERE Account='%s' LIMIT 1",PlayerName(playerid));
mysql_query(sql);
            mysql_store_result();
            mysql_fetch_row(row);
            split(row,field,'|');
            mysql_free_result();
            format(string,sizeof(string),"%s\n",field[0]);

I have linked 2 character in my account but in the dialog, I have only one line.

Can Anyone help me ?

[Marricio]

Try using strcat

[Shidony]

It workd but now it shows me 2 times the same name.

Normally, it should show me:

Lorenzo_Turner
Shawn_Miller

But it show me:

Lorenzo_Turner
Lorenzo_Turner

Is there an error in my query ?

[Shidony]

Up please