Displaying simple blog or news category list in side bar, and archives

Hi geminiman7,

To build a link for Archives and Categories sidebar, load the blog records first and get each records' date and category.
I.e. blog dates are from the 'createdDate' field which will be stored as array in $archiveDates, categories are from 'category' field which will be stored as array in $archiveCategories

list($blogRecords, $blogMetaData) = getRecords(array(
    'tableName'   => 'blog',
    'loadUploads' => false,
    'allowSearch' => false,
  ));

$archiveDates      = array(); // for "ARCHIVES" sidebar links
$archiveCategories = array(); // for "CATEGORIES" sidebar links
foreach ($blogRecords as $record){
  $archiveDates[date('Y-m', strtotime($record['createdDate']))] = date('F, Y', strtotime($record['createdDate']));
  $archiveCategories[$record['category']]                       = $record['category:label'];
}

And to display the links for the "Archives", loop through the $archiveDates. Ie:

// display M, Y links
foreach ($archiveDates as $linkParam => $monthYear){
  echo "<a href='blog-archive.php?date=".htmlencode($linkParam)."'>".htmlencode($monthYear)."</a>";
}

Do the same for "Categories". Ie:

// display category links
foreach ($archiveCategories as $linkParam => $categoryName){
  echo "<a href='blog-archive.php?categoryNum=".htmlencode($linkParam)."'>".htmlencode($categoryName)."</a>";
}

Finally, to select the blog records depending on the selected date or category, you can build a where clause based from the URL parameter. Ie:

// archive list page
$where = 'TRUE';
if (@$_REQUEST['date']){
  $where .= " AND createdDate LIKE '".mysql_escape($_REQUEST['date'])."%'";
}
elseif (@$_REQUEST['categoryNum']){
  $where .= " AND category = '".mysql_escape($_REQUEST['categoryNum'])."'";
}

list($blogRecords, $blogMetaData) = getRecords(array(
    'tableName'   => 'blog',
    'where'       => $where,
    'loadUploads' => true,
    'allowSearch' => false,
  ));

Hope that helps!

Cheers,

Hi geminiman7,

The $record['listFieldName:label'] is a variable added by getRecords() function when you have a list field with "fieldValue|fieldLabel" options set in section editor. 
For example, you have a list field with options like below wherein Category B selected:
1|Category A
2|Category B
3|Category C

The $record['listFieldName'] will return '2'. While $record['listFieldName:label'] will return 'Category B'. 

For the issue with missing variables, you should also add the getRecords() and foreach block for constructing the $archiveDates and $archiveCategories and rename the $blogRecords variable so it doesn't conflict with the one you used for displaying the archive list.
For example:

// blog records for sidebar archive menu
list($sidebarArchiveBlogRecords, $archiveBlogMetaData) = getRecords(array(
    'tableName'   => 'blog',
    'loadUploads' => false,
    'allowSearch' => false,
  ));

$archiveDates      = array(); // for "ARCHIVES" sidebar links
$archiveCategories = array(); // for "CATEGORIES" sidebar links
foreach ($sidebarArchiveBlogRecords as $record){
  $archiveDates[date('Y-m', strtotime($record['createdDate']))] = date('F, Y', strtotime($record['createdDate']));
  $archiveCategories[$record['category']]                       = $record['category:label'];
}

If you're going to have the sidebar in other pages, you might want to put the sidebar code into another file then use "include()" to display it in other pages.

Let me know any questions.

Cheers,