MySql INSERT and then ...

[jdaura]

I have a form right now that updates a mysql database after 'submit' (post) and I was wondering how then I could then have the script take the user to a confirmation page with another form containing some of the variables form this first form.

The mysql insert after form submit looks like this :

if($POST['op']=="Update Records") {
$edit = $POST['edit'];
$query = "UPDATE requests SET action2_date='".date('Y-m-d H:i:s', time())."' WHERE request_id=";
if(is_array($edit)) {
foreach($edit as $rid => $value) {
mysql_query($query.$rid);
$i++;
}
}
print '<h3>Post Submitted: ' .$i.' records updated.</h3>';
}

After the UPDATE how could I bounce the user to another page/form with info from the POST ?

Thanks, Cheers,

JD

[marian]

you can use header("location: newpage.php?id="rid)

in newpage.php you select back what the user had entered in the previous page from the database using the "id". and then you populate it onto your form.

goodluck