how do I write this INSERT so that it works

Question

Basically I want to put "todays" year, month, day into two fields ... something like the following. Tried varients of but cant get it right

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

Answer 1

?

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

EDIT: I'd love to hear why people are downvoting this...

Answer 2

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

You have six columns, so you need six values.

If you have two sets of three values, you need to repeat the same values.

You want to use bind variables instead of direct interpolation (? instead of '$year').

Answer 3

Not sure what your column types are so I'm assuming they are numeric...

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)