$select = "select recno,name from TABLE;";
$result=$db->exec("$select");

my @row;
while (@row = $result->fetchrow)
{
   $recno = $row[0];
   $name  = $row[1];
}