problem in inserting data into the database

[muazuzanna]

i am having problem in inserting data into my database,because says to me that query is not executed. the codes are shown below

<?php
//include("connection.php");
//print_r($_POST);
 
$firstname = $_POST['txtfirstname'];
$lastname = $_POST['txtlastname'];
$email = $_POST['txtaddress'];
$date = $_POST['txtdate'];
$user="killer";
$host="localhost";
$password="killer08";
$database="register";
//creating connection 
$Con = mysql_connect($host,$user,$password)
		or die("couldn't connect to server");
//connecting to database.	
$db = mysql_select_db($database,$Con)or die("no database found");
$query = "INSERT INTO tblregister set (firstname,lastname,emailaddress,date) values ($firstname,$lastname,$email,$date)";
$result = mysql_query($query)
	or die('query failed');
?>

[amigura]

delete set from insert

$query = "INSERT INTO tblregister set (firstname,lastname,emailaddress,date) values ($firstname,$lastname,$email,$date)";