why is this query not working

[SquirrelJ]

i amtrying to run this query through my phpmyadmin but keep getting an error message

Error
SQL query: 

INSERT INTO 'movie'(

'movie_id',
'movie_name',
'movie_type',
'movie_year'
)
VALUES (
'1', 'Bruce Almighty', '1', '2003'
) 

MySQL said:  

#1064 - 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'
('movie_id', 'movie_name', 'movie_type', 'movie_year')
values
('1', '' at line 2 

Does anyone know why it is erroring

cheers

[laserlight]

Single quotes should not be used to delimit identifier names. You should use double quotes, though in the case of MySQL backticks are usually used instead:

INSERT INTO `movie`(
	`movie_id`,
	`movie_name`,
	`movie_type`,
	`movie_year`
)
VALUES (
	'1', 'Bruce Almighty', '1', '2003'
);