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 7004 Aug 2, 2002, 4:34 PM
Thread Re: [Evoir] Random Global Questions
afinlr 6881 Aug 2, 2002, 5:14 PM
Thread Re: [afinlr] Random Global Questions
Evoir 6958 Aug 3, 2002, 9:24 AM
Thread Re: [Evoir] Random Global Questions
afinlr 6899 Aug 3, 2002, 11:22 AM
Post Re: [afinlr] Random Global Questions
Evoir 6867 Aug 3, 2002, 11:49 AM
Thread Re: [afinlr] Random Global Questions
Paul 6878 Aug 3, 2002, 11:56 AM
Thread Re: [Paul] Random Global Questions
Evoir 6890 Aug 3, 2002, 12:02 PM
Thread Re: [Evoir] Random Global Questions
afinlr 6819 Aug 3, 2002, 12:52 PM
Thread Re: [afinlr] Random Global Questions
Evoir 6821 Aug 7, 2002, 1:08 PM
Post Re: [Evoir] Random Global Questions
Evoir 6760 Aug 8, 2002, 2:45 PM
Thread Re: [Paul] Random Global Questions
afinlr 6848 Aug 3, 2002, 12:18 PM
Thread Re: [afinlr] Random Global Questions
Paul 6899 Aug 3, 2002, 12:43 PM
Thread Re: [Paul] Random Global Questions
Evoir 6768 Sep 13, 2002, 11:41 AM
Thread Re: [Evoir] Random Global Questions
Alex 6810 Sep 13, 2002, 12:34 PM
Thread Re: [Alex] Random Global Questions
Evoir 6724 Sep 13, 2002, 12:49 PM
Thread Re: [Evoir] Random Global Questions
Alex 6749 Sep 13, 2002, 1:42 PM
Post Re: [Alex] Random Global Questions
afinlr 6689 Sep 13, 2002, 3:37 PM
Post Re: [Alex] Random Global Questions
Evoir 6696 Sep 13, 2002, 4:34 PM
Post Re: [Alex] Random Global Questions
Evoir 6685 Sep 13, 2002, 4:37 PM
Post Re: [Alex] Random Global Questions
Evoir 6731 Sep 13, 2002, 4:56 PM