[BaubaS]

pawn Код:

new
    Query[ 56 ]
;

format            ( Query, 51, "SELECT * FROM `playersdb` ORDER BY `Job` = '%d'", pData[ playerid ][ pJob ] );
mysql_query       ( Query );
mysql_store_result(       );
SendClientMessage ( playerid, -1, mysql_num_rows( ) );
mysql_free_result (       );

format            ( Query, 56, "SELECT `Name` FROM `playersdb` ORDER BY `Job` = '%d'", pData[ playerid ][ pJob ] );
mysql_query       ( Query );
mysql_store_result(       );
SendClientMessage ( playerid, Query );
mysql_free_result (       );

Is this will work? From first query I want to know how much more people there are in that job, and from second query I want to their names. Sorry for bad indentation, forum fucked it up.