if i execute a query in mysql select dialprefix,rateinitial from cc_ratecard where (dialprefix='001' or dialprefix='00123') ORDER BY LENGTH(dialprefix) DESC;
result
row1 | 001 | 0.01000 |
row22 | 00123 | 0.02000 |
and this is lua code
local rates = {}
local count = "";
assert(dbh:query(query, function(qrow)
for key, val in pairs(qrow) do
rates[key] = val
freeswitch.consoleLog("INFO"," rates :"..key.. "..="..val.." \n")
end
count = qrow.count;
end))
questios is
1 how to select 2nd row from result ?
2 how to count total rows ?
3 how to print all 2 rows in console ?
any suggestios wellcome