sql error on trying to update a table

[statusquo]

Hello everyone.

I am trying to update a table using posted form variables, but I get a sql error after hitting the submit button. The error message I get is : Invalid Query : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''movie_name' = 'Test2', 'movie_year' = '2005', 'movie_type' = '

This is my query statement :

$sql = "UPDATE movie
SET
'movie_name' = '".$POST['movie_name']."',
'movie_year' = '".$POST['movie_year']."',
'movie_type' = '".$POST['movie_type']."',
'movie_leadactor' = '".$POST['movie_leadactor']."',
'movie_director' = '".$POST['movie_director']."'
WHERE
'movie_id' = '".$GET['id']."'";

I have been looking at this for hours and can't find the error... my eyes are tired Any help would be appreciated. TIA

[laserlight]

fieldnames are not delimited by single quotes.
You either leave them as they are, or use backticks (`) in MySQL.

[statusquo]

LOL... thank you so much.

I am laughing because I used back ticks on this page and several others .... though "no that can't be right"... then edited them all to have single quotes.

Thanks again.