Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [afinlr] link to link's category?

Quote Reply
Re: [afinlr] link to link's category? In reply to
i corrected that line, but am still getting the compile error - any ideas?

Code:
sub {
# Displays the newest links on the home page.

# Get the link information
my ($output,$sth,$link);
my $search_db = $DB->table('Links');
$search_db->select_options ('ORDER BY Add_Date DESC Limit 5');
$sth = $search_db->select ( { isNew => 'Yes', isValidated => 'Yes' });
while ($link = $sth->fetchrow_hashref) {
# Get the links category information
my $catdb = $DB->table('CatLinks', 'Category');
my $catsth = $catdb->select ({ 'LinkID' => $id }, ["Full_Name"]);
$link->{category} = $catsth->fetchrow_array;

$output .= Links::SiteHTML::display ('include_nav_newlinks_format', $link);
}
return $output;
}

regan
Subject Author Views Date
Thread link to link's category? ryel01 2162 Mar 18, 2004, 1:08 AM
Thread Re: [ryel01] link to link's category?
fuzzy logic 2083 Mar 18, 2004, 8:04 AM
Thread Re: [fuzzy logic] link to link's category?
ryel01 2078 Mar 18, 2004, 12:59 PM
Thread Re: [ryel01] link to link's category?
afinlr 2063 Mar 18, 2004, 3:13 PM
Thread Re: [afinlr] link to link's category?
ryel01 2051 Mar 18, 2004, 10:31 PM
Thread Re: [ryel01] link to link's category?
fuzzy logic 2034 Mar 18, 2004, 11:23 PM
Post Re: [fuzzy logic] link to link's category?
ryel01 2045 Mar 18, 2004, 11:42 PM
Post Re: [fuzzy logic] link to link's category?
ryel01 2023 Mar 19, 2004, 1:35 AM