Home : Products : Gossamer Links : Development, Plugins and Globals :

Products: Gossamer Links: Development, Plugins and Globals: Re: [kzap] Prevent additions to main categories: Edit Log

Here is the list of edits for this post
Re: [kzap] Prevent additions to main categories
hmm nahh, im looking for something simpler, maybe a more simpler category loop. Thanks to a previous global from Andy, I've come up with this, I just need to know how to make it get all those which FatherID is greather than 0 ? Anyone?

sub {
my $table = $DB->table('Category');
my $return_cats;

$table->select_options ('ORDER BY Name ASC');
my $sth = $table->select( { FatherID => '0' } );

while (my $hit = $sth->fetchrow_hashref) {
$return_cats .= "<option value=\"" . $hit->{ID} . "\">" . $hit->{Full_Name} . "</option>";
}

return $return_cats;
}

Last edited by:

kzap: Sep 14, 2003, 10:34 PM

Edit Log: