Q:Display latest record in preview after inserting

[congfuzi]

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

[pthes]

I don't know if this is what you want, but I suggest changing your approach. I don't see why you want to send the user to another page after they have updated a record. Instead how about if the record which is being updating shows the current data from each field as the default value. When you submit to update the record now the new data will be displayed. This way if a change has to be made it can be done quickly since you're already at the update screen.