Sorry, my mistake. You DO need the Date.
To get a random entry, just add this global:
get_random_fact
my $tbl = $DB->table('Facts');
$tbl->select_options('ORDER BY RAND()');
my $fact = $tbl->select()->fetchrow_hashref;
return $fact->{Fact};
}
Then call with:
Fact: <%get_random_fact%>
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!
To get a random entry, just add this global:
get_random_fact
Code:
sub { my $tbl = $DB->table('Facts');
$tbl->select_options('ORDER BY RAND()');
my $fact = $tbl->select()->fetchrow_hashref;
return $fact->{Fact};
}
Then call with:
Fact: <%get_random_fact%>
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!