12.03.2015, 16:25
I know, but you can fetch player name at the same time in single query:
(warning, return field names can be different due to aliases!)
pawn Code:
SELECT h.*, p.name FROM houses h LEFT JOIN players p ON p.id = h.owner_id