10.06.2010, 08:45
Hi $ЂЯĢ, i need your help, how i can restore my result with this query:
stock GetPlayerHouses(playerid)
{
new playername[MAX_PLAYER_NAME+10], sql[128];
GetPlayerName(playerid, playername, sizeof(playername));
format(sql, sizeof(sql), "SELECT ArrayID FROM houses WHERE Owner = '%s' AND Dates = 1", playername);
mysql_query(sql);
mysql_store_result();
}
In tables 3-4 same owner names, i need return all ArrayIDS, where Owner is playername and Dates = 1, it possible 2-3 playername in one table.
Regards.
stock GetPlayerHouses(playerid)
{
new playername[MAX_PLAYER_NAME+10], sql[128];
GetPlayerName(playerid, playername, sizeof(playername));
format(sql, sizeof(sql), "SELECT ArrayID FROM houses WHERE Owner = '%s' AND Dates = 1", playername);
mysql_query(sql);
mysql_store_result();
}
In tables 3-4 same owner names, i need return all ArrayIDS, where Owner is playername and Dates = 1, it possible 2-3 playername in one table.
Regards.