<?php
$_DB_USE_MYSQLI = true;
require 'db.connect.php';
require '_pagewrapper.php';
wrapPageTop( 'current.php', 'blog archive' );
?>
<style type="text/css">
ul
{
list-style: none;
margin-bottom: 2em;
margin-top: 0em;
}
ul li
{
margin-left: -2.5em;
}
</style>
<?php
$blog_history_query_string = <<<EOQ
SELECT
DATE_FORMAT( bp.postDateTime, '%M %Y' ),
DATE_FORMAT( bp.postDateTime, '%M %D' ),
bp.postURL,
bp.blogPostTitle,
(
SELECT COUNT(*)
FROM tblBlogPostComments
WHERE blogPostID = bp.blogPostID
)
FROM tblBlogPosts bp
WHERE bp.isVisible = 1
ORDER BY bp.postDateTime DESC
EOQ;
$blog_history_query = $mysql->prepare( $blog_history_query_string );
$blog_history_query->execute();
$blog_history_query->bind_result( $post_month, $post_date, $post_url, $post_title, $comment_count );
$last_month_header = '';
while ( $blog_history_query->fetch() )
{
if ( $last_month_header != $post_month )
{
if ( strlen( $last_month_header ) )
{
?>
</ul>
<?php
}
$last_month_header = $post_month;
?>
<h3><?php print strtolower( $last_month_header ); ?></h3>
<ul>
<?php
}
?>
<li><?php print $post_date; ?>: <a href="/current/<?php print $post_url; ?>" target="_top"><?php print $post_title;?></a></li>
<?php
}
$blog_history_query->close();
?>
</ul>
<?php
wrapPageBottom();
?>