news archive

[thomas]

Hey guys.

Just wondering how to change the Date function in the latest news plugin.

Currently it only shows the date created.

I have found the code on line 36 something in the db. But i was stuck.

// get the articles
$getarticles = $DB->query("SELECT articleid, categoryid, title, author, IF ( n.dateupdated = 0, n.datecreated, n.dateupdated )as date

I tried making the n.dateupdated != 0 etc but yeah not working

any help?

thanks. thomas

[thomas]

mm dont worry ive worked it out, by just using the dateupdated in the select statement.

But that has made me wonder....

when i go into a news article and edit the description - it dosent update the articles date?