I'm trying to insert a new record in the database tabel "movie_group" witht he following query:
$sql = "INSERT INTO movie_group (movie, group) VALUES ('$movie_id','22')";
but I get the following error message:
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 'group) VALUES ('8018','22')' at line 1
The fields "movie" and "group" exist in the tabel. The other fields of the tabel have default values.
Do you know whats wrong with the query?