I have been using javascript to move from one page to another when I want to do someting before I actually go to another page
For instance
<php>
if ($checkout) {
$sql = mysql_query("INSERT INTO orders(orderid, userid, ip, itemnumber, upc, title, prebookdate, releasedate, dvd_status, price, qty, subtotal, timestamp, hold, weight) VALUES ('$new_string', '$dvd_id', '$dvd_ip', '$dvd_davisid', '$dvd_upc', '$dvd_title', '$dvd_preorderdate', '$dvd_releasedate', '$status', '$dvd_price','$dvd_qtty1', '$subtotal', '$stamp', 'shipall', '$weight')") or die (mysql_error());
$result = mysql_query($sql);
?>
<script language="JavaScript">
window.open("options2.php", target="_self")
</script>
<?
}
</php>
is there a better way to do this?
I thought about transfer to another page to do the update and delete queries but I was hoping there was something else I could do.