[Bogdan1992]

Check the positions with a message

pawn Код:

new string2[50];
format(string2, 50, "x: %f, y:%f, z:%f", floatstr(x), floatstr(y), floatstr(z));
SendClientMessage(playerid, -1, string2);

EDIT: Try now,

pawn Код:

stock MySQL_House(playerid)
{
    new query[300], pname[24], savingstring[20],string1[128], x[20], y[20], z[20];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "SELECT * FROM `house`");
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query,"|"))
    {
        mysql_fetch_field_row(savingstring, "houseid"); HouseID[playerid] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Owner"); HouseOwner[playerid] = strval(savingstring);
        mysql_fetch_field_row(x, "xHPos");
        mysql_fetch_field_row(y, "yHPos");
        mysql_fetch_field_row(z, "zHPos");

        format(string1, sizeof string1, "House Owner: %s\nX:%d, Y:%d,Z:%d\nHouse ID:%d", HouseOwner, floatstr(x), floatstr(y), floatstr(z), strval(HouseID));
        CreatePickup(1273, 1, floatstr(x), floatstr(y), floatstr(z));
        Create3DTextLabel(string1, 0xFFFFFFFF, floatstr(x), floatstr(y), floatstr(z), 10.0, 0, 0);

    }
    mysql_free_result();
    return 1;
}