Ok, heres a simple idea. Create a new global, say 'linkowner_name'. Add the following code into it;
my $User= shift;
my $table = $DB->table('Users');
my $sth = $table->select( { Username => $User } );
my $Name;
while (my $hit = $sth->fetchrow_hashref) {
$Name = $hit->{Name};
}
$Name ? return $Name : return "None";
}
Ten call it with something like;
<%linkowner_name($LinkOwner)%>
Untested, but it should work (only problems may be the field names). This should work for all the field names. Simply replace the parts in red with the new field name.
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!
Code:
sub { my $User= shift;
my $table = $DB->table('Users');
my $sth = $table->select( { Username => $User } );
my $Name;
while (my $hit = $sth->fetchrow_hashref) {
$Name = $hit->{Name};
}
$Name ? return $Name : return "None";
}
Ten call it with something like;
<%linkowner_name($LinkOwner)%>
Untested, but it should work (only problems may be the field names). This should work for all the field names. Simply replace the parts in red with the new field name.
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!