Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: Adding links to homepage

Quote Reply
Re: Adding links to homepage In reply to
Create a global with the following code:

my $search_db = $DB->table('Links');
$search_db->select_options ('ORDER BY Add_Date DESC', 'LIMIT 1');
my $sth = $search_db->select;
while (my $hit = $sth->fetchrow_hashref) {
$output .= qq!
$hit->{Title}<BR>$hit->{URL}
$hit->{Description}!; }
return $output;
~;

You can try that out but Im not sure if it is correct as I can't remember the table names of the top of my head.

Paul Wilson.
new - http://www.wiredon.net
Subject Author Views Date
Thread Adding links to homepage afinlr 9676 Feb 23, 2001, 1:51 PM
Thread Re: Adding links to homepage
Paul 9375 Feb 23, 2001, 2:04 PM
Thread Re: Adding links to homepage
afinlr 9365 Feb 24, 2001, 9:27 AM
Thread Re: Adding links to homepage
Paul 9371 Feb 24, 2001, 9:33 AM
Thread Re: Adding links to homepage
afinlr 9395 Feb 24, 2001, 9:44 AM
Thread Re: Adding links to homepage
Paul 9387 Feb 24, 2001, 9:47 AM
Thread Re: Adding links to homepage
afinlr 9367 Feb 24, 2001, 9:58 AM
Thread Re: Adding links to homepage
Paul 9426 Feb 24, 2001, 10:02 AM
Thread Re: Adding links to homepage
BryanL 9421 Feb 24, 2001, 12:32 PM
Thread Re: Adding links to homepage
Alex 9352 Feb 26, 2001, 11:41 PM
Thread Post deleted by TheFox
TheFox 9304 Mar 22, 2001, 8:07 AM
Thread Re: Adding links to homepage
afinlr 9240 Mar 23, 2001, 6:46 AM
Thread Re: Adding links to homepage
TheFox 9349 Mar 23, 2001, 7:30 AM
Post Re: Adding links to homepage
TheFox 9224 Mar 25, 2001, 1:38 AM
Thread Re: Adding links to homepage
TheFox 9240 Apr 7, 2001, 6:21 AM
Thread Re: Adding links to homepage
TheFox 9161 Apr 16, 2001, 7:48 AM
Thread Re: Adding links to homepage
Paul 9159 Apr 16, 2001, 7:54 AM
Thread Re: Adding links to homepage
TheFox 9186 Apr 16, 2001, 7:59 AM
Post Re: Adding links to homepage
Paul 9193 Apr 16, 2001, 8:02 AM
Thread Re: Adding links to homepage
Paul 9148 Apr 16, 2001, 8:07 AM
Thread Re: Adding links to homepage
TheFox 9131 Apr 16, 2001, 8:34 AM
Thread Re: Adding links to homepage
Paul 9117 Apr 16, 2001, 8:44 AM
Thread Re: Adding links to homepage
TheFox 9124 Apr 16, 2001, 9:17 AM
Thread Re: Adding links to homepage
TheFox 9131 Apr 16, 2001, 9:19 AM
Thread Re: Adding links to homepage
Paul 9120 Apr 16, 2001, 12:59 PM
Thread Re: Adding links to homepage
Robert 3203 Apr 16, 2001, 3:01 PM
Post Re: Adding links to homepage
Paul 3189 Apr 16, 2001, 3:09 PM
Thread Re: Adding links to homepage
Robert 3192 Apr 16, 2001, 3:18 PM
Thread Re: Adding links to homepage
Paul 3158 Apr 16, 2001, 3:29 PM
Thread Re: Adding links to homepage
Robert 3144 Apr 16, 2001, 4:36 PM
Post Re: Adding links to homepage
pugdog 3128 Apr 16, 2001, 11:16 PM
Post Re: [afinlr] Adding links to homepage
Alba 3025 Aug 11, 2002, 6:50 AM