[iryston]

I tried but it went wrong. if someone can help me, thank you!

Example, i have a list of admins in my db, and i want show in the server on /listadmins

[S4t3K]

Are you sure to know how to use MySQL ? (or just SQL, it's the BASICS of the language)

Use a SELECT query, use cache_num_rows as a maximum to your for loop then display the player names you would have gotten from the SELECT query using cache_get_field_content or cache_get_row using your loop variable as row index.

[iryston]

So. Firstly thank you for being here.
Well, sorry, MySQL
in my attempts the most I could get was, showing the amount of admins who was in the table. The name, with level etc.. not returned. did not show. i used SendClientMessage, Printf to show but, dont works..

sorry my english

[S4t3K]

Your english is good enough to be understood.

Try this way

PHP код:


// In your command
mysql_tquery(yourHandle, "SELECT `name`, `admin` FROM `Players` WHERE `admin` >= 1", "OnAdminsFound_", "i", playerid); // here, playerid = the id of the player who has launched the command

// At the bottom of your script

forward OnAdminsFound_(playerid);
public OnAdminsFound_(playerid)
{
      new name[MAX_PLAYER_NAME+1], rank, string[145];
      for(new i = 0; i < cache_num_rows(); i++)
      {
            cache_get_row(0, 0, name);
            rank = cache_get_row_int(0, 1);
            format(string, sizeof(string), "Admin name : %s | Admin level : %d", name, rank);
            SendClientMessage(playerid, -1, string);
      }
      return 1;
} 


[iryston]

I got it! now worked

Thank you so much!

++REP