The if statement is around the recordset loop:
<?php if ("".($Archive->getColumnVal("Live")) ."" == "1") { ?>
<?php
while(!$Archive->atEnd()) {
?>
<div style="line-height:150%;font: 16px Arial, Helvetica, sans-serif;color:#fff; margin:0 20px;"><a href="newsarchive.php?NewsMonth=<?php echo($Archive->getColumnVal("ContentMonth")); ?>&NewsYear=<?php echo($Archive->getColumnVal("ContentYear")); ?>"> <?php echo($Archive->getColumnVal("contDate")); ?> (<?php echo($Archive->getColumnVal("cc")); ?>)<br/>
</a></div>
<?php
$Archive->moveNext();
}
?>
<?php } ?>
it needs to be inside the recordset loop instead:
<?php
while(!$Archive->atEnd()) {
?>
<?php if ("".($Archive->getColumnVal("Live")) ."" == "1") { ?>
<div style="line-height:150%;font: 16px Arial, Helvetica, sans-serif;color:#fff; margin:0 20px;"><a href="newsarchive.php?NewsMonth=<?php echo($Archive->getColumnVal("ContentMonth")); ?>&NewsYear=<?php echo($Archive->getColumnVal("ContentYear")); ?>"> <?php echo($Archive->getColumnVal("contDate")); ?> (<?php echo($Archive->getColumnVal("cc")); ?>)<br/>
</a></div>
<?php } ?>
<?php
$Archive->moveNext();
}
?>