Joomla模板覆盖最新的类别文章

Question

Guys, I've got an problem... I am using an alternative layout for articles in a certain category. My aim is to display an extra div (with an background-image) for the Newest article of the category. And this should only effect the newest article.

So, as I am not familiar with the Joomla-API. I would now like to know what's the best way to determine (in PHP/MySQL/whatever) if an article is the newest article of its category?

Thanks for a reply (Btw. I am using J1.6)

Ripei

Answer 1

This code should do the trick

    $db=& JFactory::getDBO();
    $query = 'SELECT * FROM #__content ORDER BY created DESC';
    $db->setQuery($query);
    $showcat = $db->loadObjectList();