[Tutorial] How to fetch a result set from a MySQL database. The correct way.

[Y_Less]

What if what the database stores increases (excess data), changes order (messed up parsing), or decreases (no error checking)? Often yes, you do want all the data, I'd still argue that it's better to be explicit but won't push it as you do have a point too.

[mamorunl]

Some small errors in your code: the function name should be "OnHousesLoaded" (yours is OnHouseLoaded) and the i++ should be idx++

Other than that, great tutorial

[Johnson_boy]

Originally Posted by irinel1996

You don't like the cache functions? As I see you didn't use it. As BlueG said it's much faster.
Nice one.

This is definitely better way than querying the database separately for each house, yet
the cache functions of BlueG's plugin are even faster. Therefore I would recommend
anyone to use the cache functions.