is there a global to display the recent isNew links and also the isChanged links together?

So can someone help if i add {isChanged => 'Yes'} to the code, it'll only look for links with both isNew and isChanged, but how can i display the latest isNew and isChanged links?

my $sth = $db->select ( { isNew => 'Yes'},{isChanged => 'Yes'},{ isValidated => 'Yes'} );

Try with:

my $sth = $db->select ({ isNew => 'Yes', isChanged => 'Yes', isValidated => 'Yes' });

That will still look for links with both isNew and isChanged equal yes!

No it won't, it will display links with isChanged = Yes


It sounded like that was what you were asking for in your OP....

>>
but how can i display the latest isNew and isChanged links?
<<

If not, can you explain more to make things clearer?

Sorry if my question was confusing.. but i need latest links with either the isNew and isChanged eq to Yes..

Payooo's suggestion was correct in that case as long as you use select_options to order and limit what you want.

Anyway you can show me how to use the selection option to do that Paul?

Hey Paul, I tried that, I return any links!

You need a condition statement with OR. If you click on help in your admin and then GT Module Documentation you should see 'Condition' down the left side of the page (under SQL). This tells you how to use it. Also search the forum for condition and you should get some examples.

Laura.
The UK High Street

Just checked back my last post, i meant when i use Paul's code, it didn't return any links:!

Do you definitely have 10 links where isNew, isValidated and isChanged are all Yes?

I just checked over the code and I can't see any reason why it would fail.

That's because it is looking for links which are both new and changed - I don't think that new links are ever changed links as well. You need an OR condition if you want either new or changed.

I want to display links with either isNew or isChanged so Laura was right. Looking the forum and docs to see how to use OR condition now, but seems pretty confusing!

Hey Laura, I got it working to the point where it would display isNew or isChanged link, but however i can't seem to get the ORDER BY condition to work with ADD_DATE and MOD_DATE, right now it sorts that all isNew first and isChanged last!

sub {

# Displays New links by category.

my ($output,$sth,$link);

require GT::SQL::Condition;

my $id = shift;

my $db = $DB->table ('Links','CatLinks');

$db->select_options ('ORDER BY ADD_DATE DESC', 'LIMIT 10');

my $cond = GT::SQL::Condition->new (

'isNew', '=', 'Yes',

'isChanged', '=', 'Yes'

);

$cond->bool ('OR') ;

my $sth = $db->select ($cond, { isValidated => 'Yes' });

my $premium;

while ($link = $sth->fetchrow_hashref) {

$output .= Links::SiteHTML::display ('newlinks', $link);

}

return $output;

}

If you use Mod_Date instead of Add_Date - doesn't that do what you want? The Mod_Date will be the same as Add_Date for new links so I think this should work.
The UK High Street

All worked out fine, thank you!