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

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org