your if statement will only look at the first record:
<?php if ("".($Archive->getColumnVal("Live")) ."" != "1") { ?>
No archive at present
<?php } ?>
you would need to loop through the recordset to determine if there are any live records, for example:
<?php
$anyLive = "0";
while(!$Archive->atEnd()) {
if($Archive->getColumnVal("Live") == "1") {
$anyLive = "1";
}
$Archive->moveNext();
}
$Archive->moveFirst();
?>
<?php if ("".($anyLive) ."" != "1") { ?>
No archive at present
<?php } ?>