Php Contact form Help

[ace2721]

Hi Guys I have a contact form which i have managed to put together, and yes sorry I am a newbie to php so please forgive me if this is very easy. I need the form to go to a confirmation page after submit but i cant get it to work, at the moment when you click submit it displays a little message, I need to get rid of that and put in place the forward please can some one help I will include the script below

 

I have been trying to insert the following scrip but unsure where header("Location: http://www.mydomain.co.uk/emailconfirm.htm");

 

<?php

// Connect to database
$hostname = "1.1.1.1";
$username = "user";
$password = "pass";
$dbname = "data";
$usertable = "table";
$f_name = $_REQUEST['f_name'];
$tel = $_REQUEST['tel'];
$email = $_REQUEST['email'];


mysql_connect($hostname, $username, $password) or DIE("Unable to connect to MySQL server $hostname");

$selected = mysql_select_db($dbname) or DIE("Could not select requested db $dbname");


$query = "INSERT INTO pitman (id, f_name, tel, email, pdate) VALUES ('', '$f_name', '$tel', '$email' , NOW())"; 
   
$results = mysql_query($query) or DIE  ("could not execute query : $query." . mysql_error()); 

$result = mysql_query($query) or DIE("Could not Execute Query on table $usertable");

mysql_close;

$errmsg  = ''; // error message
$f_name   = ''; // sender's name
$tel = ''; // message tel
$email   = ''; // sender's email addres


if(isset($_POST['send']))
{
$f_name   = $_POST['f_name'];
$tel = $_POST['tel'];
$email = $_POST['email'];

if(trim($f_name) == '')
{
	$errmsg = 'Please enter your name';
}
else if(trim($tel) == '')
{
	$errmsg = 'Please enter Your Telephone Number:';
}
else if(trim($email) == '')
{
	$errmsg = 'Please enter your email address';
}
else if(!isEmail($email))
{
	$errmsg = 'Your email address is not valid';
}
if($errmsg == '')
{
	if(get_magic_quotes_gpc())
	{
		$tel = stripslashes($tel);
		$message = stripslashes($message);
	}	

	// the email will be sent here
	$to      = "[email protected]";

	$user_message .= "Name: $f_name \r\n"; 
	$user_message .= "tel: $tel \r\n"; 
        $user_message .= "email: $email \r\n"; 
        $headers = "- company \r\n"; 
        $headers .= "Reply-To: $email"; 


	mail('[email protected]','company',$user_message,$headers);

	header("Location: http://www.mydomain.co.uk/emailconfirm.htm");
?>
<div align="center" class="bigger">
  <p>Thank you for sending your details, we look forward to seeing you on the 21st May</p>
  <p>   </p>
</div>
  <?php
}
}


if(!isset($_POST['send']) || $errmsg != '')
{
?>
<div align="center" class="smallblue"><?=$errmsg;?></div>
<form  method="post" name="msgform" id="msgform">
  <table border="0" align="left" cellpadding="2" cellspacing="1" class="maincell">
    
    <tr>
      <td class="smallblue">Your Name</td>
      <td><input name="f_name" type="text" class="eqform" id="sname" style="width:100px" value="<?=$f_name;?>" /></td>
      <td> </td>
    </tr>
    <tr>
      <td class="smallblue">Email </td>
      <td><input name="email" type="text" class="eqform" id="hnum" style="width:100px" value="<?=$email;?>"/></td>
      <td> </td>
    </tr>
      <tr>
      <td width="100" class="smallblue">Contact Number </td>
      <td><input name="tel" type="text" class="eqform" id="tel" value="<?=$tel;?>" style="width:100px" /></td>
      <td><input name="send" type="submit" id="send" value="Send" onclick="return checkForm();" /></td>
    </tr>
  </table>
</form>
<?php
}

function isEmail($email)
{
return(preg_match("/^[-_.[:alnum:]]+@((([[:alnum:]]|[[:alnum:]][[:alnum:]-]*[[:alnum:]])\.)+(ad|ae|aero|af|ag|ai|al|am|an|ao|aq|ar|arpa|as|at|au|aw|az|ba|bb|bd|be|bf|bg|bh|bi|biz|bj|bm|bn|bo|br|bs|bt|bv|bw|by|bz|ca|cc|cd|cf|cg|ch|ci|ck|cl|cm|cn|co|com|coop|cr|cs|cu|cv|cx|cy|cz|de|dj|dk|dm|do|dz|ec|edu|ee|eg|eh|er|es|et|eu|fi|fj|fk|fm|fo|fr|ga|gb|gd|ge|gf|gh|gi|gl|gm|gn|gov|gp|gq|gr|gs|gt|gu|gw|gy|hk|hm|hn|hr|ht|hu|id|ie|il|in|info|int|io|iq|ir|is|it|jm|jo|jp|ke|kg|kh|ki|km|kn|kp|kr|kw|ky|kz|la|lb|lc|li|lk|lr|ls|lt|lu|lv|ly|ma|mc|md|mg|mh|mil|mk|ml|mm|mn|mo|mp|mq|mr|ms|mt|mu|museum|mv|mw|mx|my|mz|na|name|nc|ne|net|nf|ng|ni|nl|no|np|nr|nt|nu|nz|om|org|pa|pe|pf|pg|ph|pk|pl|pm|pn|pr|pro|ps|pt|pw|py|qa|re|ro|ru|rw|sa|sb|sc|sd|se|sg|sh|si|sj|sk|sl|sm|sn|so|sr|st|su|sv|sy|sz|tc|td|tf|tg|th|tj|tk|tm|tn|to|tp|tr|tt|tv|tw|tz|ua|ug|uk|um|us|uy|uz|va|vc|ve|vg|vi|vn|vu|wf|ws|ye|yt|yu|za|zm|zw)$|(([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5])\.){3}([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5]))$/i"
		,$email));
}

?>

[Ken2k7]

I hope you're aware that you ran the $query twice. Also, I believe you need the parentheses in mysql_close.