local function getSubKat( n )
    local sk = {}
    if n ~= nil then
        for row in db:nrows("SELECT  * FROM Subkat WHERE hkid = '"..n.."' ORDER BY skid") do
            -- create table at next available array index

            local val =
            {
                skid = row.skid,
                skname = row.skname
            }

            table.insert(sk, val)
            print("sk:")
            print(sk[#sk].skname)
        end

    end
    return sk
end

print(getSubKat( 1 )[1].skname)

for row in db:nrows("SELECT  * FROM Huvudkat ORDER BY hkname") do
    -- create table at next available array index
    local val =
    {
        hkid = row.hkid,
        hkname = row.hkname,
        skat = getSubKat( hkid )
    }
    table.insert(hk, val)
    print("hk:")
    print(hk[#hk].skat)
end

--[[

2013-03-24 01:33:05.705 Corona Simulator[23997:707] sk:
2013-03-24 01:33:05.705 Corona Simulator[23997:707] Drinks with alcohol
2013-03-24 01:33:05.705 Corona Simulator[23997:707] sk:
2013-03-24 01:33:05.706 Corona Simulator[23997:707] Juice
2013-03-24 01:33:05.706 Corona Simulator[23997:707] sk:
2013-03-24 01:33:05.706 Corona Simulator[23997:707] Drinks without alcohol
2013-03-24 01:33:05.707 Corona Simulator[23997:707] Dryck with alkohol
2013-03-24 01:33:05.707 Corona Simulator[23997:707] hk:
2013-03-24 01:33:05.707 Corona Simulator[23997:707] table: 0x114bb3fd0
2013-03-24 01:33:05.707 Corona Simulator[23997:707] hk:
2013-03-24 01:33:05.708 Corona Simulator[23997:707] table: 0x1084bde90
2013-03-24 01:33:05.708 Corona Simulator[23997:707] hk:
2013-03-24 01:33:05.708 Corona Simulator[23997:707] table: 0x111cb2ce0
2013-03-24 01:33:05.708 Corona Simulator[23997:707] hk:
2013-03-24 01:33:05.709 Corona Simulator[23997:707] table: 0x11384e6f0
2013-03-24 01:33:05.709 Corona Simulator[23997:707] hk:
2013-03-24 01:33:05.709 Corona Simulator[23997:707] table: 0x10c2dedd0
2013-03-24 01:33:05.709 Corona Simulator[23997:707] hk:
2013-03-24 01:33:05.709 Corona Simulator[23997:707] table: 0x111cc6380
2013-03-24 01:33:05.710 Corona Simulator[23997:707] hk:
2013-03-24 01:33:05.710 Corona Simulator[23997:707] table: 0x10dad2d70
2013-03-24 01:33:05.710 Corona Simulator[23997:707] hk:
2013-03-24 01:33:05.710 Corona Simulator[23997:707] table: 0x1115d9ef0
2013-03-24 01:33:05.711 Corona Simulator[23997:707] hk:
2013-03-24 01:33:05.711 Corona Simulator[23997:707] table: 0x1125fb890
2013-03-24 01:33:05.711 Corona Simulator[23997:707] hk:
2013-03-24 01:33:05.711 Corona Simulator[23997:707] table: 0x10da72a80
2013-03-24 01:33:05.711 Corona Simulator[23997:707] hk:
2013-03-24 01:33:05.711 Corona Simulator[23997:707] table: 0x1125bbb20
2013-03-24 01:33:05.712 Corona Simulator[23997:707] hk:
2013-03-24 01:33:05.712 Corona Simulator[23997:707] table: 0x111b02ce0
2013-03-24 01:33:05.712 Corona Simulator[23997:707] hk:
2013-03-24 01:33:05.712 Corona Simulator[23997:707] table: 0x111b67ec0
]]--