Nice catch - I'm guilt of copying that if statement from another page and not changing the rs name.
Works perfectly now - go figure!
Thank you again. It is great to have a second set of eyes with this stuff.
I want to share something else I did on this page that I think would serve others as well.
I cannot have people coming BACK to this page, becuase it will trigger the visit count, so I added another counter, based on session values.
<?php
session_start();
if(isset($_SESSION['views']))
$_SESSION['views'] = $_SESSION['views']+ 1;
else
$_SESSION['views'] = 1;
?>
Then, I wrapped the FORM tags with
<?php if ($_SESSION['views'] == 1) { // Adv Conditional Region ?>
<form>
... form stuff ....
</form>
<?php } // $_SESSION['views'] == 1 ?>
Works perfectly and is a much simpler way of preventing the inadvertent post of data than anything else I could find online.
If someone backs out of the confirmation page, they just see a blank page (with navigation) when they get back to this counting page, and since there is no form, there is no update.