Grouping articles per year

Hi Zaba, 

It is with a little custom code, do you want articles by year with paging (10 articles per page), or a list of year links to show articles by a specific year?  Or just a simple list of articles sorted by year with a header in the list for each year? 

Sometimes it's easier to design how you want the page to look and then work in reverse from there.

Let me know, thanks!

Hey there

This is pretty simple - all you need to do is change the where clause on the regular index page to add in the year, if it exists, from the $_REQUEST array.

The year links should look like so:

http://www.yoursite.com/articles.php?year=2014

Then the regular index page will have a getRecords call that looks like this:

if(@$_REQUEST['year'] != "") {
    $where = "year = '".mysql_escape($_REQUEST['year'])."'";
}
else {
    $where = "TRUE";
}

list($articles, $articlesMeta) = getRecords(array(
    'tableName' => 'articles',
    'where' => $where
));