If/Else for goto pages

You created this if/else scenario for me, but now I have three choices instead of two.


<a href="PORC_Member_Round_<?php echo($rsBatchRecords->getColumnVal("sendto_second_round")?"2":"1"); ?>_Ballot.php?record_number=<?php echo ($rsBatchRecords->getColumnVal("record_number")); ?>"><?php echo($rsBatchRecords->getColumnVal("record_number")); ?></a>

The new choices are:

If the field “ebird_expedited” is true, then go to PORC_Member_ebird_Ballot.php

Else if “sendto_second_round” is true, then go to PORC_Member_Round_2_Ballot.php

Else go to PORC_Member_Round_1_Ballot.php


How should that be written?

Single line IF statements get complex after a couple. I'd break it out into multiple IF statements above like:

<?php

$pageName = "PORC_Member_Round_1_Ballot.php";

if ($rsBatchRecords->getColumnVal("sendto_second_round")) $pageName = "PORC_Member_Round_1_Ballot.php";

if ($rsBatchRecords->getColumnVal("ebird_expedited")) $pageName = "PORC_Member_ebird_Ballot.php";

?>

<a href="<?php echo($pageName); ?>_Ballot.php?record_number=<?php echo ($rsBatchRecords->getColumnVal("record_number")); ?>"><?php echo($rsBatchRecords->getColumnVal("record_number")); ?></a>

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.

Please attach the page so I can look at the code to see what might be wrong.

See attached file.

The code that updates the url isn't on the page you attached.

I don't understand. What code? What url?

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";

?>

Is not on the page you attached. I think you attached the wrong page? It looks like the recordset name is different on this page as well.

Here is the file again. PORC_Admin_Non_Batch_Records.php

I see that the recordset name in the If statements was wrong. I corrected that and now I get URL Not Found.