[bosmania]

I'm working on a clan system and i want to show the clan owner a list with all the members and i tried like this but it won't show me the members,it will show me this message SELECT * FROM `users` WHERE `users`.`Clanid` = 4

case 0:
{
format(szQuery, sizeof(szQuery), "SELECT * FROM `users` WHERE `users`.`Clanid` = '%d'", PlayerInfo[playerid][pClanid]);
new Cache: result = mysql_query(mysql, szQuery);
cache_delete(result);
ShowPlayerDialog(playerid, DIALOG_CLANMEMBERS, DIALOG_STYLE_TABLIST_HEADERS, "Clan members:", szQuery, "Select", "Cancel");
}