Not inputting info into mysql database

[Anon]

I have created an html submit info page and a php page. The php is not inputting the info to the database...any help is appreciated ..following is my php page ( I get the following error after trying the post Parse error: parse error, unexpected $ in c:\inetpub\wwwroot\submitform.php on line 21 -there is nothing on line 21-) ..thank you
<?php

mysql_connect (localhost, root, "my password");

mysql_select_db ("my database");

mysql_query ("INSERT INTO "my table"(Website, FirstName, LastName, Title, WorkPhone, HomePhone, MobilePhone, EmailName)
VALUES ('$Website', '$FirstName', '$LastName', '$Title', '$WorkPhone', '$HomePhone', '$MobilePhone', '$EmailName')
");'on die ("INSERT UNSUCCESSFUL");

print ($FirstName);

print ($LastName);

print ("<p>");

print ("Thanks for submitting your Info.");

?>

[Anon]

mysql_query ("INSERT INTO my table(Website, FirstName, LastName, Title, WorkPhone, HomePhone, MobilePhone, EmailName)
VALUES ('$Website', '$FirstName', '$LastName', '$Title', '$WorkPhone', '$HomePhone', '$MobilePhone', '$EmailName')
");'or die ("INSERT UNSUCCESSFUL");

try that

Regards, Stezz.

[metin]

You have a syntax error in the "mysql_query"!
Do it like this instead:
<?php
mysql_connect (localhost, root, "my password");

mysql_select_db ("my database");

$sql = "INSERT INTO your_table ";
$sql .="(Website, FirstName, LastName, Title, WorkPhone, HomePhone, MobilePhone, EmailName) ";
$sql .="VALUES ";
$sql .="('$Website', '$FirstName', '$LastName', '$Title', '$WorkPhone', '$HomePhone', '$MobilePhone', '$EmailName')";

mysql_query("$sql") or die ("INSERT UNSUCCESSFUL");

print ($FirstName);

print ($LastName);

print ("<p>");

print ("Thanks for submitting your Info.");
?>

[metin]

The actuall error was on the following:
");'or die ("INSERT UNSUCCESSFUL");

it should be:
") or die ("INSERT UNSUCCESSFUL");

[Anon]

The last one did it, Metin!