Restricting $query results to field value passed at end of URL

Hi All,

As I mentioned in post 2232090, I’m using the following on a blog viewer to create an “archive” list of unique months and years with posts

$query = "SELECT DATE_FORMAT(date, '%M %Y') as dateAndYear, YEAR(date) as year, MONTH(date) as month FROM cms_blog GROUP BY dateAndYear ORDER BY date";
$result = mysql_query($query) or die("MySQL Error: ". htmlspecialchars(mysql_error()) . "\n");
while ($record = mysql_fetch_assoc($result)):
?>
<a href="blog2.php?date_year=<?php echo $record['year'] ?>&date_month=<?php echo $record['month'] ?>&orderBy=<?php echo $orderBy ?>"><?php echo $record['dateAndYear']; ?> </a><br/>
<?php endwhile ?>

I ’m restricting the article records that are shown on the page to those where a field called blog_chapter equals the request at the end of the URL IE: http://www.mysite.com/blog.php?blog_chapter=Chapter-One

My problem is that I have no idea how to place that same limitation on the $query that creates the unique "archive" list on the page.

Hope someone can help.

Thanks,

Jerry Kornbluth