ODBC Insertion Query

[BulldogGC]

			if (isset($_GET['add']) && $_GET['add'] == "true") {
				$sql_insert_genres = "insert into genres (name) values ('$name')";
				$query_insert_genres = odbc_exec($db,$sql_insert_genres);	
			}

What's wrong with that piece of code someone please? It's saying when the URL -- http://www.whatever.com/whatever.php?add=true -- is defined you should run the insertion query ... but the actual query is tossing up errors. "$name" is from the previous page containing the input field "name" ... any help would be appreciated, thanks.

[__TCN__]

Shouldn't it be $_POST["name"] instead of $name?

~ ('".$_POST["name"]."') ~

[BulldogGC]

Doesn't seem to work.
This is the revised code ...

$query_insert = odbc_exec($db,"INSERT INTO genres (name) VALUES ('".$_POST["name"]."')");

And this is the error:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in ...