Using this code:
<?php
$pageName = "PORC_Admin_Batch_Round1_Form.php";
if ($rsBatchRecords->getColumnVal("send_to_second_round")) $pageName = "PORC_Admin_Batch_Round2_Form.php";
if ($rsBatchRecords->getColumnVal("ebird_expedited")) $pageName = "PORC_Admin_Batch_eBird_Form.php";
?>
<a href="<?php echo($pageName); ?>?record_number=<?php echo ($rsNewRecords->getColumnVal("record_number")); ?>"><?php echo($rsNewRecords->getColumnVal("record_number")); ?></a>
It always goes to the first page "PORC_Admin_Batch_Round1_Form.php"
It does not appear to be parsing the IF statements correctly.
Both "send_to_second_round" and "ebird_expedited" are TinyInt (1/0) fields.