[Shaheen]

hai all
i have a doubt
i am currently working with a /myhouses command.
it should actually give a dialog showing the houses owned by the player
so how can i do it ?
i am using mysql r39-2
so i have stuck with this

PHP код:

new query[200],cache:houses;
format(query,sizeof(query),select houseid where owner = %s,getplayername(playerid));
houses=....... 


and how to do the remaining like getting the houseid and saving.
can we do with sscanf ?
i am new with mysql r39..

thanks in advance.