Parsing a table

[Ploo]

I have some code that grabs songs from a SQLite table. It returns a table, as you'd expect which looks like the following:

1:
                artist  =       Trapt
                length  =       286
                title   =       Head Strong
                VCode   =       LBeg7CZqSx0
2:
                artist  =       Rise Against
                length  =       254
                title   =       Hero of War
                VCode   =       TdXq20oJlC0
3:
                artist  =       Rise Against
                length  =       226
                title   =       From Heads Unworthy
                VCode   =       CpKGWGqq7OQ

What would be the easiest way of parsing it? I really have no clue, tried a few things but all failed. I'm ideally looking for something that will loop through all the keys and give me row["artist"] and so on.

[toneo]

I'd do:

for k,v in ipairs(tablehere) do
	local artist = v["artist"]
	local length = v["length"]
	local title = v["title"]
	local vcode = v["vcode"]
end

That will loop through the table and fetch you the artist, length, etc.

[yakahughes]

Or if you're not sure whether you'll ever add more fields, you could do:

[lua]
for k,v in pairs(tablehere) do
for k,v in pairs(v) do
-- k and v will equal artist and Trapt the first time round, length and 286 the second, etc
end
end[/lua]

[Ploo]

Worked this out myself, by simply a numbered loop Songs[1], Songs[2] but this seems better.

Thanks guys.