my $link_db = $DB->table('Links') || return $GT::SQL::error;
$link_db->select_options ('ORDER BY Add_Date ASC') || return $GT::SQL::error;

my $sth = $link_db->select( GT::SQL::Condition->new(
isValidated => '=' => 'Yes',
ExpiryDate => '>=' => time


) );

my $temp_distance;

while (my $link = $sth->fetchrow_hashref)
{

while (my $link = $sth->fetchrow_hashref)
{
$temp_distance = distance($olat, $olon, $link->{Latitude}, $link->{Longitude}, $unitcode);

if($temp_distance <= $dist)
{
$link_count++;
$link->{distance} = $temp_distance;
$link = Links::SiteHTML::tags('link', $link);
push (@link_results_loop, $link);
}
}
}