Another Blog Question - Archives

3 posts by 2 authors in: Forums > CMS Builder
Last Post: January 24, 2012   (RSS)

One more question pertaining to the blog I'm creating. :-)

You can see the my sample page here: http://www.ihelpinc.net/Blog/category.php

The main blog list is here: http://www.ihelpinc.net/Blog/index.php

In order to create an archive function of the blog (to list blog posts by month and year, etc.), I used the suggestion given here: http://www.interactivetools.com/iforum/gforum.cgi?post=83311;search_string=blog;t=search_engine#83311. (THANKS DONNA!) :-)

It works great. However, I seem to be experiencing an unwanted effect when selecting a date from the archive.

** When clicking an "archive" link (such as "January 2012"), not only does the page display a list of all blog posts from January 2012 (which is correct), but the "Recent Posts" list is also filtered. Obviously, we want the "Recent Posts" to always show the same recent posts and not be changed or filtered by selections made in the "Archive" or "Category" sections. Is there a way to close off the "Recent Posts" section to keep it from being affected by "Archive" or "Category" selections?

Here is some of the code I'm using:

FROM PAGE TOP:

// load records
list($blog_contentRecords, $blog_contentMetaData) = getRecords(array(
'tableName' => 'blog_content',
'loadUploads' => '0',
));
$blog_contentRecord = @$blog_contentRecords[0]; // get first record


// load records
list($blog_categoriesRecords, $blog_categoriesMetaData) = getRecords(array(
'tableName' => 'blog_categories',
'loadUploads' => '0',
'allowSearch' => '0',
));



FROM PAGE BODY:

<!-- RECENT POSTS MODULE -->
<div id="BigRightBottom">
<h3 style="margin-left:-10px; color:#333;">RECENT POSTS</h3>
<?php
// load records
list($blog_contentRecords, $blog_contentMetaData) = getRecords(array(
'tableName' => 'blog_content',
'limit' => '7',
'loadUploads' => '0',
));
?>
<p style="margin: 0px 10px 0px 10px;">
<?php foreach ($blog_contentRecords as $record): ?>
<a href="<?php echo $record['_link'] ?>"><?php echo $record['title'] ?></a><br />
<?php endforeach ?>
</p>
</div>
<!-- /end RECENT POSTS MODULE -->




<!-- BLOG ARCHIVE MODULE -->
<div id="BigRightBottom">
<h3 style="margin-left:-10px; color:#333;">ARCHIVE</h3>
<p style="margin: 0px 10px 0px 10px;">
<?php require_once "/home/content/66/8739966/html/cmsAdmin/lib/viewer_functions.php"; ?>

<?php
// get list of unique months and years with articles
$query = "SELECT DATE_FORMAT(date, '%M %Y') as dateAndYear, YEAR(date) as year, MONTH(date) as month FROM cms_blog_content GROUP BY dateAndYear ORDER BY date DESC";
$result = mysql_query($query) or die("MySQL Error: ". htmlspecialchars(mysql_error()) . "\n");
while ($record = mysql_fetch_assoc($result)):
?>

<a href="index.php?date_year=<?php echo $record['year'] ?>&date_month=<?php echo $record['month'] ?>"><?php echo $record['dateAndYear']; ?></a><br/>

<?php endwhile ?>
</p>
</div>
<!-- /end BLOG ARCHIVE MODULE -->



Thanks for any assistance!

Kindest regards,
Jeremy
---------------------------

Dwelling Productions

www.dwellingproductions.com

Re: [Jason] Another Blog Question - Archives

Thanks again Jason!!! You rock!!! :-)

Seriously, I really appreciate your taking the time to guide me to the solution for this (along with my other request). I learned a lot through the process of working on this that I'll definitely be able to apply to future CMSB projects.

Many (many, many, many) thanks!

- Jeremy
---------------------------

Dwelling Productions

www.dwellingproductions.com