Hi,
Try this:
my $categoryID = $_[0];
my $tbl = $DB->table('Editors');
$tbl->select_options('LIMIT 1');
my $editor = $tbl->select( { CategoryID => $categoryID } )->fetchrow_hashref;
my $user = $DB->table('Users')->select( { Username=> $editor->{'Username'} } )->fetchrow_hashref;
my $return;
map { $return->{$_} = $user->{$_} } keys %$user;
map { $return->{$_} = $editor->{$_} } keys %$editor;
return $return;
}
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!
Try this:
Code:
sub { my $categoryID = $_[0];
my $tbl = $DB->table('Editors');
$tbl->select_options('LIMIT 1');
my $editor = $tbl->select( { CategoryID => $categoryID } )->fetchrow_hashref;
my $user = $DB->table('Users')->select( { Username=> $editor->{'Username'} } )->fetchrow_hashref;
my $return;
map { $return->{$_} = $user->{$_} } keys %$user;
map { $return->{$_} = $editor->{$_} } keys %$editor;
return $return;
}
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!