[RESOLVED] PARSE ERROR

[mohvmark]

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /hsphere/local/home/mhovmark/somewhatproduced.com/php/addevent.php on line 9

<?php
$user="mhovmar_todolist";
$password="mattrock";
$database="mhovmar_todolist";
mysql_connect("mydb3.surftown.se",$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$event=$_POST['event_name'];
print ".$event. ";
$sql = 'INSERT INTO Event (id_nr, name, date, finished) VALUES ('''', ''vafan33'', ''0000-00-00'', '''')';
?>

Im just trying to put something in my database. Does God not exist? What is wrong with this?

[laserlight]

$sql = 'INSERT INTO `Event` (`id_nr`, `name`, `date`, `finished`) VALUES ('''', ''vafan33'', ''0000-00-00'', '''')';

probably should be:

$sql = "INSERT INTO `Event` (`id_nr`, `name`, `date`, `finished`) VALUES ('', 'vafan33', '0000-00-00', '')";