Goto after submit

I have a Page (Page 3) that can be called from either Page 1 or Page 2.

When I hit Submit on Page 3, I want it to return to the Page that called it.

Page 1 is PORC_Admin_Vote_Pending_List.php
Page 2 is PORC_Admin_All_Votes_List.php
Page 3 is PORC_Admin_Vote_Pending_Record.php

How can I capture the page name and use it as the submit GoTo file?

You could save the last page name as a session variable on both the possible previous pages and use the session variable to redirect. Just use the same session variable name and whichever page was visited last will be redirected to.

I set a session variable on pages 1 and 2 and used the Server Behavior "MYsqli Update Record" to link the GoTo file name to the session variable, but it doesn't work.

See the attached files.

You should set your session variables like this:


<?php
@session_start();
$_SESSION["gotoname"] = "PORC_Admin_All_Votes_List.php";
@session_commit();
?>

Then on your insert page, the recordsets and insert server behaviors should be above the <!doctype> tag with no blank lines in the code above it.