Hi,
At its simplest:
get_active_links
my $Links = $DB->table("Links");
$Links->select_options("ORDER BY ID ASC");
my @loop;
my $sth = $Links->select( { isValidated => "Yes" } );
while (my $hit = $sth->fetchrow_hashref) {
push @loop, $hit;
}
return { active_links_loop => \@loop }
}
Call with:
<%loop active_links_loop%>
Got: <%ID%><br />
<%endloop%>
Hope that helps.
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
At its simplest:
get_active_links
Code:
sub { my $Links = $DB->table("Links");
$Links->select_options("ORDER BY ID ASC");
my @loop;
my $sth = $Links->select( { isValidated => "Yes" } );
while (my $hit = $sth->fetchrow_hashref) {
push @loop, $hit;
}
return { active_links_loop => \@loop }
}
Call with:
Code:
<%get_active_links%> <%loop active_links_loop%>
Got: <%ID%><br />
<%endloop%>
Hope that helps.
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!