[Kingunit]

You mean you want to get all the information?

pawn Код:

new string[128], pNm[MAX_PLAYER_NAME], convert[50], var;
mysql_query("SELECT * FROM `players` WHERE `var1` > 1 AND `var2` != 1");
mysql_store_result();
while(mysql_fetch_row(pNm)) {
    format(string, sizeof(string), "SELECT * FROM `users` WHERE `name`='%s'", playersName);
    mysql_query(string);
    mysql_store_result();
    mysql_fetch_row(convert);
    var = strval(convert);
    format(string, sizeof(string), "UPDATE `users` SET `var1`='%d' WHERE `name`='%s' AND `var2`!=1", var-45, playersName);
    mysql_query(string);
}