stock LoadHouses()
{
	for(new i=0; i<MAX_HOUSES; i++)
	{
	    new query[300], savingstring[100];
	    format(query, sizeof(query), "SELECT * FROM Houses WHERE HouseID = '%d' LIMIT 1", i);
	    mysql_query(query);
	    mysql_store_result();
	    while(mysql_fetch_row_format(query,"|"))
	    {
	        mysql_fetch_field_row(savingstring, "HouseOwner");  HInfo[i][HouseOwner] = strval(savingstring);
	        mysql_fetch_field_row(savingstring, "HouseName");  HInfo[i][HouseName] = strval(savingstring);
			mysql_fetch_field_row(savingstring, "HouseID");  HInfo[i][HouseID] = strval(savingstring);
	        mysql_fetch_field_row(savingstring, "HouseCost"); HInfo[i][HouseCost] = strval(savingstring);
	        mysql_fetch_field_row(savingstring, "IconX");  HInfo[i][IconX] = strval(savingstring);
			mysql_fetch_field_row(savingstring, "IconY");  HInfo[i][IconY] = strval(savingstring);
	        mysql_fetch_field_row(savingstring, "IconZ");  HInfo[i][IconZ] = strval(savingstring);

			printf("%s %s %d %d %f %f %f",HInfo[i][HouseOwner],HInfo[i][HouseName],HInfo[i][HouseID], HInfo[i][HouseCost],HInfo[i][IconX],HInfo[i][IconY],HInfo[i][IconZ]);
	    }
	    mysql_free_result(); //We must always free a stored result
	}
}