I have two pages: insert and review. "insert" is to add new record to db, and "review" is to display the single record just added to db. The Recordset in "review" page is set to have "id" = colname with default value is 1. In Insert Record behavior on "insert" page, I set go to "review.php" after inserting.
Code for this part is below:
$insertGoTo = "review.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
Although it goes "review" page but only display 1st record. But if I add "?id=5" (assume 5 is the lastest id in recordset) after review.php, it works, which display the single latest record.
But I can not add "?id=id" to $insertGoTo = "review.php"; , cause it becomes a string then.
How can I pass the id value to $insertGoTo ?
appreciate any help!
Tony