You could try something like;
<%global_name%>
my $tags = shift;
my $table = $DB->table('Category');
$table->select_options ("ORDER BY Full_Name") || return $GT::SQL::error;
my $sth = $table->select ( ['Full_Name','ID'] ) || return $GT::SQL::error;
my $output = '<select name="CatID">';
while (my $row = $sth->fetchrow_hashref) {
$output .= '<option value='.$row->{ID}.'>'.$row->{Title}.'</option>';
}
$output .= '</select>';
return $output;
}
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!
<%global_name%>
Code:
sub { my $tags = shift;
my $table = $DB->table('Category');
$table->select_options ("ORDER BY Full_Name") || return $GT::SQL::error;
my $sth = $table->select ( ['Full_Name','ID'] ) || return $GT::SQL::error;
my $output = '<select name="CatID">';
while (my $row = $sth->fetchrow_hashref) {
$output .= '<option value='.$row->{ID}.'>'.$row->{Title}.'</option>';
}
$output .= '</select>';
return $output;
}
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!