on the news page, the default value for the URLParam in the DatePostedRS is set to "1", that must not be a value that is the database. use a valid value for the default value.
look at the links you have, what are the values for the zNews querystring variable? use one of those.
for the special offers page, you are using a URL variable named:
zSpecial Offers
you cannot have spaces in URL variables names, recreate the links so the URL variables does not contain spaces in the name:
<a href="special-offers.php?zSpecialOffers=<?php echo $row_SpecialPanelRS['ContentPageSetOrder']; ?>"">
and edit the recordset so that the run time value for the URLParam of the DatePostedRS recordset is:
$_GET['zSpecialOffers']