Thanks again. I followed option 1 and its working, I see the values entered and it inserts - I added recordset filtered by session variable to display.
I have another question, how do I do a calculation e.g: recordset_value1 + recordset_value2 and display it. Another example would be a dropdown form field value on the form page:
<?php
If ($Recordset1->getColumnVal("value1") == '500 - 999') {
$myquote = 200;
}
?>
If I run this on the browser, it gives undefined variable myquote. I want to display myquote as 200 if the dropdown selected is '500 - 999'
Please help with this final one.