Hi all,
I have a form, lets call it sales_sp.htm
In this form i need to send five values from the text input fields as well as 3 hidden fields. Upon submitting the form process_sales_sp.php is executed. (The script is below) As you can see this inserts the form values into the database then goes to the header location. Being relatively new to PHP can anyone tell me how to spass the values that were placed into the database onto the header location...ie. https://www.securepay.com.au/securepay/payments/process.asp
<?
$ponum = date("YmdHi");
$db = mysql_connect('localhost', '', '');
if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db("rip");
$query = "insert into securepay(name, address, city, postcode, telephone, instructions, ponum, optional_info, amount, merchantid) values('$name' ,'$address','$city','$postcode','$telephone','$instructions','$ponum','$optional_info','$amount','$merchantid')";
$result=mysql_query($query);
if($result)
header ("Location: https://www.securepay.com.au/securepay/payments/process.asp");
?>
