Hi Mark. Thanks for jumping in.
$rsPATIENT->getColumnVal("PFpatientID") exists on the page. Is it only when the UPDATE form submits that it disappears?
If that's the case then why does it work on my other UPDATE form considering that the UpdateGoTo reference is the same?
Here's the reference on the form where it does work, on page (examination-view.php which I attach):
$UpdateGoTo = "patient-view.php?pID=".$rsPATIENT->getColumnVal("PFpatientID")."";
Here's the referece on the form where it's failing (examination-edit.php, also attached):
$UpdateGoTo = "patient-view.php?pID=".$rsPATIENT->getColumnVal("PFpatientID")."";
I'm completely stumped by this.
NJ
EDIT: As advised, I've created a hidden form field with the patient ID and have appended that to the redirect URL and, hey presto, it works fine.
I still have no idea why it works for one UPDATE form and not the other though.
Thank you Mark.