Hi There,
I have just completed my very first DB and had one heck of a time doing it. My question is this, when a user inputs data and then clicks submit it uses the echo command(??) and displays the info just added but I want it just to re-direct to a Thank You page or some other page. Here is the code for adding the info....
<HTML>
<title>Adding information...</title>
<body>
<?PHP
$name = $POST['name'];
$address = $POST['address'];
$postal = $POST['postal'];
$delivery = $POST['delivery'];
$nondelivery = $POST['nondelivery'];
$latedelivery = $POST['latedelivery'];
$notusingmailbox = $POST['notusingmailbox'];
$other = $POST['other'];
$otherdesc = $POST['otherdesc'];
$comments = $POST['comments'];
$yes = $POST['yes'];
$no = $POST['no'];
$number = $POST['number'];
$email = $POST['email'];
mysql_connect("flyerforce.ca","flyerforce","bSJFs91q")or die(mysql_error());
mysql_select_db("flyerforce")or die(mysql_error());
mysql_query("INSERT INTO resident_services VALUES('$name','$address','$postal','$delivery','$nondelivery','$latedelivery','$notusingmailbox','$other','$otherdesc','$comments','$yes','$no','$number','$email')");
echo "The following values:<br>
Name: $name<br>
Address: $address<br>
Postal Code: $postal<br>
Date of delivery: $delivery<br>
Concern about Delivery: <br><br>
Non-Delivery: $nondelivery<br>
Late Delivery: $latedelivery<br>
Not using the mailbox: $notusingmailbox<br>
Other: $other<br>
Please Specify: $otherdesc<br>
Comments about this delivery: $comments<br>
Would you like a representative to contact you?<br><br>
Yes: $yes<br>
No: $no<br>
Phone number: $number<br>
Email Address: $email<br>
was successfully added to the db";
mysql_close();
?>
Thanks in advance for your help!!!
