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

Re: [Evoir] Random Global Questions

Quote Reply
Re: [Evoir] Random Global Questions In reply to
You can ignore links without a description by adding a condition line:

my $condition = GT::SQL::Condition->new( 'Description', 'IS NOT', \'NULL','isValidated','=','Yes');

Add it below your select option line.

And then you can add $condition into both lines which select from the Links database

$sth = $link_db->select ( $condition ,{ CategoryID => $cat_id });

and

my $sth3 = $link_db->select ( $condition, { CategoryID => $child_id});



Paul - I think that you need to resort the array because otherwise you will always get links from the main category or the first subcategory - the new links are just added on the end of the array as the code goes down the list of subcategories, so if you want to give the links in the last subcategory a chance of appearing I think you need this extra sort?
The UK High Street
Subject Author Views Date
Thread Random Global Questions Evoir 6906 Aug 2, 2002, 4:34 PM
Thread Re: [Evoir] Random Global Questions
afinlr 6783 Aug 2, 2002, 5:14 PM
Thread Re: [afinlr] Random Global Questions
Evoir 6861 Aug 3, 2002, 9:24 AM
Thread Re: [Evoir] Random Global Questions
afinlr 6803 Aug 3, 2002, 11:22 AM
Post Re: [afinlr] Random Global Questions
Evoir 6770 Aug 3, 2002, 11:49 AM
Thread Re: [afinlr] Random Global Questions
Paul 6781 Aug 3, 2002, 11:56 AM
Thread Re: [Paul] Random Global Questions
Evoir 6793 Aug 3, 2002, 12:02 PM
Thread Re: [Evoir] Random Global Questions
afinlr 6722 Aug 3, 2002, 12:52 PM
Thread Re: [afinlr] Random Global Questions
Evoir 6724 Aug 7, 2002, 1:08 PM
Post Re: [Evoir] Random Global Questions
Evoir 6662 Aug 8, 2002, 2:45 PM
Thread Re: [Paul] Random Global Questions
afinlr 6750 Aug 3, 2002, 12:18 PM
Thread Re: [afinlr] Random Global Questions
Paul 6802 Aug 3, 2002, 12:43 PM
Thread Re: [Paul] Random Global Questions
Evoir 6671 Sep 13, 2002, 11:41 AM
Thread Re: [Evoir] Random Global Questions
Alex 6713 Sep 13, 2002, 12:34 PM
Thread Re: [Alex] Random Global Questions
Evoir 6627 Sep 13, 2002, 12:49 PM
Thread Re: [Evoir] Random Global Questions
Alex 6651 Sep 13, 2002, 1:42 PM
Post Re: [Alex] Random Global Questions
afinlr 6593 Sep 13, 2002, 3:37 PM
Post Re: [Alex] Random Global Questions
Evoir 6599 Sep 13, 2002, 4:34 PM
Post Re: [Alex] Random Global Questions
Evoir 6588 Sep 13, 2002, 4:37 PM
Post Re: [Alex] Random Global Questions
Evoir 6634 Sep 13, 2002, 4:56 PM