php - Form header:location sequence order -

hi i'm trying redirect next page after data sumbmitted mysql. have far

<?php $name = ""; $email = ""; $msg_to_user = ""; if ($_post['name'] != "") {     include_once "newsletter/connect_to_mysql.php";      // sure filter data deter sql injection, filter before querying database     $name = $_post['name'];     $email = $_post['email'];      $sql = mysql_query("select * newsletter email='$email'");     $numrows = mysql_num_rows($sql);      if (!$email) {       $msg_to_user = '<br /><br /><span style="font color="ff0000">please type email address ' . $name . '.</span>';      } else if ($numrows > 0) {       $msg_to_user = '<br /><br /><font color="ff0000">' . $email . ' in system.</font>';      } else {           $sql_insert = mysql_query("insert newsletter (name, email, datetime)          values('$name','$email',now() )")  or die (mysql_error());       $msg_to_user = '<br /><br /><div style="color=#f47926;">thanks ' . $name . ', lets select need.</div>';       $name = "";       $email = "";     }     header("location: order.php"); } ?> 

this sends data database , works great, i'd send page @ order.php thats created continue. form i've got right here

<form style="border:0;padding-left:10px;" action="<?php echo $_server['php_self']; ?>" method="post">   <fieldset style="text-align:left;" id="free">    <span style="text-align:left;font-size:30px;color:#f47926;">     ready started?   </span>   <div class="centerform">     name:<br />     <input name="name" type="text" maxlength="36" size="35" value="" /><br />      email:<br />     <input name="email" type="text" maxlength="36" size="35" value="" /><br />     <br /><br /><div style="width:179px;margin-left:auto;margin-right:auto;"><input type="image" src="continue-to-selection.png" name="mysubmitbtn" alt="continue selection" /></div>                           </fieldset>  </form> 

the email function worked before, stopped working began changes. i'm sure simple , i'm sure can work out. issue i'm trying re-direct after submission of data mysql, user page order.php. changes need make supposed within form or through header:location i'm trying use. note: shortened urls view within post preview here i'm aware order.php must full path. correct me if i'm wrong, letting know aware , not issue.

there 2 approches suggest try. 1st 1 (personally prefered) use ajax , jquery submit form , display thank message without refreshing page. after use settimeout function delay redirect x seconds , redirect order page.

2nd approche: after data saved in database store success message in session. in header of order page, use if statement based on session. if it's success or true show message thank message in order page.

if want see example of solutions provided, let me know.

thanks