Latest Article on index page

[wowsaver]

here is a very easy way to add your latest article on your index page.

in index_default.tpl.php
just before the last </table>
add:

        <tr>
            <td class="main">
                <?php
                    $article_info_query = tep_db_query("select a.articles_id, a.articles_date_added, a.authors_id, ad.articles_name, ad.articles_description" . TABLE_ARTICLES . " a left join " . TABLE_AUTHORS . " au using(authors_id), " . TABLE_ARTICLES_DESCRIPTION . " ad where a.articles_status = '1' and ad.articles_id = a.articles_id and ad.language_id = '" . (int)$languages_id . "' order by a.articles_date_added desc limit 0,1");
                    $article_info = tep_db_fetch_array($article_info_query);
                    ?>
                    <table border="0" width="100%" cellspacing="0" cellpadding="2" align="center" bgcolor="#b6b7cb">
                    <tr><td class="infoBoxHeading" align="center">Latest Article: <?php echo $article_info['articles_name']; ?></td></tr>            
                    <tr><td class="productinfo"><?php echo $article_info['articles_description']; ?></td></tr>
                    </table>
            </td>
        </tr>

Demo at http://self-defense-tools.com

[michael_s]

That is a useful bit of hacking. I am sure it will get a lot of use! I appreciate you posting it up.