Sorted.. thanks Ray
Not sure if its ok to continue through this thread but I will as you have FTP/DB access
I now have this problem:
using basic PHP calculation as value for database update
<?php
$totalCost = ($rsCalculate->getColumnVal('no_of_flats') * 75) + ($rsCalculate->getColumnVal('no_of_blocks') * 500);
?>
The recordset is built from a session variable that is created from an 'Insert record behaviour" on the previous page you are directed from.
This works fine as I have tried binding $totalCost into the page and it shows.
I want to bind this value to a column value in an “Update record behaviour” that is triggered by an access rule that checks a URL variable value.
The binding comes from a small form with a single hidden element that holds the $totalCost value.
The “Update record behaviour” is being triggered as I use a redirect to the same page with a url variable test. The problem is the $totalCost value is not passing.
The two pages in question here are
https://www.rtmf.org.uk/admin/new-enquiry.php
https://www.rtmf.org.uk/admin/enquiry-list.php