Problem storing data into mySQL

1

As the title says, I’m trying to store data from an html form into a mySQL database. This is what I have, but it gives me an error about the syntax.


$Message = $_POST['Message'];
$Name = $_POST['Name'];

$connection = mysql_connect('localhost', 'e_novative', 'e_novative') or  die("failure to connect to mySQL server" . mysql_error());
if (!mysql_select_db('db_test', $connection))
{
        echo("cannot select db". mysql_error());
}
$sql = "INSERT INTO table_data ('Message', 'Name') VALUES ('$Message', '$Name')";
$result = mysql_query($sql, $connection);
if ($result) {
       echo("<p>data stored successfully</p>");
} else {
       die('error querying db' . mysql_error());
}

Theres more to the code, but I removed the unrelated bits. It says the error is within the $sql line. Hope you can help. Thanks :pleased:

BTW: Can someone tell me when to use post and get?!