how do I write this INSERT so that it works

INSERT INTO film_out
(start_year, start_month, start_day, end_year, end_month, end_day)
VALUES
(?,?,?,?,?,?)

"INSERT INTO film_out (start_year, start_month, start_day, end_year, end_month, end_day)
      VALUES ('$year', '$month', '$day', '$year', '$month', '$day')"

INSERT INTO film_out (start_year, start_month, start_day, end_year, end_month, end_day)
VALUES (YEAR(), MONTH(NOW()), DAYOFMONTH() + 1, YEAR(), MONTH(NOW()), DAYOFMONTH() + 1)