How to sum up 1 column and set it as a new record (total time of each member per month) in new table

Programming in mysql: How to sum up 1 column and set it as a new record (total time of each member per month) in new table on newest questions tagged mysql – Stack Overflow

How does one sum up czas column which is time(H:m) records from table raport and set it as a new record (as total time of each member per month) in new table’s (time) june column?

I’m trying something like this, but it doesn’t work.

mysql_query("INSERT INTO time (czerwiec) SELECT SUM(czas) FROM raport WHERE data BETWEEN '2012-06-01' AND '2012-06-30'") or die ('{"success":"false"}');

source: http://stackoverflow.com/questions/11206199/how-to-sum-up-1-column-and-set-it-as-a-new-record-total-time-of-each-member-per
Programming in mysql: programming-in-mysql