These are a few of the responses I get when I try to edit either an actor or a director....and I have absolutely no idea what it all means or even wjere to start looking for my (an) error. Help would be appreciated.

1.) Changing Jim Carrey to Kevin Kline : 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_leadactor = 1, movie_director = 2 ' at line 4

2.) Changing director name to actor name : 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_leadactor = 1, movie_director = 6 ' at line 4

3.) Changing director "a" to director "b" : 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_leadactor = 4, movie_director = 2 ' at line 4

Unfortunately SQL errors are notoriously unhelpful. Gonna need to see the code on this one.