Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Forum : Development, Plugins and Globals :

Re: [Paul] is there tag like newest_user?

Oct 5, 2002, 7:50 AM
hoefti
User (190 posts)
hoefti's avatar
Oct 5, 2002, 7:50 AM
Views: 7062
Shortcut
Quote Reply
Re: [Paul] is there tag like newest_user? In reply to
In Reply To:
You don't touch globals.txt....you use the globals option in the control panel.

eg...

Code:
sub {
my $table = $DB->table('User');
$table->select_options("ORDER BY user_registered DESC", "LIMIT 1");
return $table->select( 'user_username' )->fetchrow;
}

That should give you the newest user.

Hello

what ist the sub for the last ten users ?


my global dosent work

Code:
sub { my $tags = shift;my $user_db = $DB->table('User');
$user_db->select_options("ORDER BY user_registered DESC', 'LIMIT 10');
my $sth = $user_db->select;my @output;
while (my $user = $sth->fetchrow_hashref) {push @output, $user;}
return { user_loop => \@output };}


Whats the Reason?

mfg hoefti
linktobuy Web Directory
Ratgeber Recht

Last edited by:

hoefti: Oct 5, 2002, 8:06 AM
Subject Author Views Date
Thread is there tag like newest_user? zaaron 7511 Mar 30, 2002, 3:03 PM
Thread Re: [zaaron] is there tag like newest_user? 		Paul 7428 Mar 31, 2002, 2:05 AM
Thread Re: [Paul] is there tag like newest_user? 		zaaron 7420 Mar 31, 2002, 3:26 AM
Thread Re: [zaaron] is there tag like newest_user? 		Paul 7403 Mar 31, 2002, 4:01 AM
Post Re: [Paul] is there tag like newest_user? 		zaaron 7399 Mar 31, 2002, 4:33 AM
Thread Re: [Paul] is there tag like newest_user? 		balita 7286 May 23, 2002, 9:16 AM
Thread Re: [balita] is there tag like newest_user? 		webmaster33 7247 May 23, 2002, 10:44 AM
Post Re: [webmaster33] is there tag like newest_user? 		balita 7264 May 23, 2002, 10:51 AM
Post Re: [webmaster33] is there tag like newest_user? 		shiner 7194 Jun 3, 2002, 1:04 PM
Thread Re: [Paul] is there tag like newest_user? 		hoefti 7062 Oct 5, 2002, 7:50 AM
Thread Re: [hoefti] is there tag like newest_user? 		Paul 7072 Oct 5, 2002, 8:07 AM
Thread Re: [Paul] is there tag like newest_user? 		hoefti 7038 Oct 5, 2002, 8:28 AM
Thread Re: [hoefti] is there tag like newest_user? 		Paul 7040 Oct 5, 2002, 8:35 AM
Post Re: [Paul] is there tag like newest_user? 		hoefti 7058 Oct 5, 2002, 8:43 AM