Grouping articles per year

Hi Dave :) 

Thanks for your answer.

I think having the index page with year links to show articles per page will be the best way to go.

Example...

2014

2015

and then I can have my articles showed on a regular index page (just for the year I want)

Thanks again!

Jesus

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
));