hello
I have the following in part of a script (not as a global) that I copied from another post in the forum. Problem is... its not working for me - returns nothing to the page. Can anyone see any problem with it?
my $cat_db = $DB->table('Category');
$cat_db->select_options ("ORDER BY Full_Name DESC");
my $sth = $cat_db->select ();
my $output .= "<select name='catid'>";
while (my $cat = $sth->fetchrow_hashref) {
$output .= "<option value='$cat->{ID}'>$cat->{Name}</option>";
}
my $output .= "</select>";
print "$output";
thank
r
I have the following in part of a script (not as a global) that I copied from another post in the forum. Problem is... its not working for me - returns nothing to the page. Can anyone see any problem with it?
Code:
my $cat_db = $DB->table('Category');
$cat_db->select_options ("ORDER BY Full_Name DESC");
my $sth = $cat_db->select ();
my $output .= "<select name='catid'>";
while (my $cat = $sth->fetchrow_hashref) {
$output .= "<option value='$cat->{ID}'>$cat->{Name}</option>";
}
my $output .= "</select>";
print "$output";
thank
r