Hi,
Try this:
paiement_id
my $table = $DB->table('Payments');
my $cond = GT::SQL::Condition->new(payments_linkid => 'LIKE' => $_[0]);
$table->select_options("ORDER BY payments_last DESC");
return $table->select('payments_id' => $cond)->fetchrow;
}
..and call with:
<%set paiement_id = paiement_id($ID)%>
..then add a new global:
get_payment_time
return $DB->table('PaymentLogs')->select( ['paylogs_time'] , { payments_id => $_[0] } )->fetchrow || die $GT::SQL::error;
}
..and call with:
<%set payment_id = get_payment_time($paiement_id)%>
That should hopefully work :)
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:
paiement_id
Code:
sub { my $table = $DB->table('Payments');
my $cond = GT::SQL::Condition->new(payments_linkid => 'LIKE' => $_[0]);
$table->select_options("ORDER BY payments_last DESC");
return $table->select('payments_id' => $cond)->fetchrow;
}
..and call with:
<%set paiement_id = paiement_id($ID)%>
..then add a new global:
get_payment_time
Code:
sub { return $DB->table('PaymentLogs')->select( ['paylogs_time'] , { payments_id => $_[0] } )->fetchrow || die $GT::SQL::error;
}
..and call with:
<%set payment_id = get_payment_time($paiement_id)%>
That should hopefully work :)
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!