The default for YahooSubcats.pm is to list sub-categories in ID order, ie: no sorting. Can anyone suggest a simple modification for alphabetical sorting?
Oct 9, 2001, 11:24 AM
User (155 posts)
Oct 9, 2001, 11:24 AM
Post #2 of 2
Views: 2175
Hi,
I'm not sure about this but try changing this:
my $table = $DB->table('Category');
my $sth=$table->select({'FatherID' => $catid},['Full_Name','Name']);
to this:
my $table = $DB->table('Category');
$table->select_options ('ORDER BY Name');
my $sth=$table->select({'FatherID' => $catid},['Full_Name','Name']);
(untested)
--
Matt G
I'm not sure about this but try changing this:
my $table = $DB->table('Category');
my $sth=$table->select({'FatherID' => $catid},['Full_Name','Name']);
to this:
my $table = $DB->table('Category');
$table->select_options ('ORDER BY Name');
my $sth=$table->select({'FatherID' => $catid},['Full_Name','Name']);
(untested)
--
Matt G