cant sumit to mysql database useing form

[rocket]

I cant sumit data in to the table for some reson i have tryed everything that i know to do it so any help would be welcome

Here is the script

<?
//Our PHP/MYSQL page.
//This script takes the data from the form
//fields and adds them to specified parts
//parts of the database
//MySQL Variables. Edit where necessary
$host = "localhost";
$login_name = "ecom";
$password = "*";

//Connecting to MYSQL
MySQL_connect("$host","$login_name","$password");

//Select the database we want to use
MySQL_select_db("ecom") or die("Could not select database");

//Assign contents of form to variables
$name = $POST['Name'];
$email = $POST['Email'];

$sql = "INSERT INTO addressbook SET
Email = "$email",
First_Name = "$name"
");

$result = mysql_query($sql);

//Code to check if statement executed properly and display message
if ($result) {
echo("Email and Name successully added");
} else {
echo("An error has occured");
}

//Close connection with MySQL
MySQL_close()
?>

<form action="script.php">
Name: <input type="text" name="Name"><br>
Email: <input type="text" name="Email">
<input type="submit" name="submit" value="submit">
</form>

[sid]

what first pops out is that the right syntax is

$sql = "INSERT INTO addressbook (Email, First_Name)
VALUES ('" . $email . "', '" . $name . "');";

instead of

$sql = "INSERT INTO addressbook SET 
Email = "$email", 
First_Name = "$name" 
"); 

you mixed up the INSERT and UPDATE syntax... your version of that statement should actually even return parse errors.

[rocket]

Thanks

[sid]

no problem...