Passing variable

[Anon]

Hi all,
Why is the following script only getting a "0" value for the "sales_cc.php?id="
Any ideas to what variable i need to pass instead of the $pay_id?

<?
{

  $pay_id = doubleval($pay_id);
  $name = addslashes($name);
  $date_in = date("Ymd");


  @ $db = mysql_pconnect('localhost', '', '');

  if (!$db)
  {
    echo "Error: Could not connect to database. Please try again later.";
	exit;
  }

  mysql_select_db("rip");

  $query = "insert into securepay(pay_id, name, address, city, postcode, telephone, instructions, ponum, optional_info, amount, merchant_id, date_in) 
  values('$pay_id','$name','$address','$city','$postcode','$telephone','$instructions','$ponum','$optional_info','$amount','$merchant_id','$date_in')";

  $result=mysql_query($query);

  if($result)
   header ("Location: sales_cc.php?id=" .$pay_id);

}

echo "<br><a href=\"membership.php\">Back to Members</a>";
?>

[Anon]

Just say
header ("Location: sales_cc.php?id=$pay_id");