SQL: loop within INSERT statement

What I’m trying to do is get the results from a form into a mysql db.
Is there a way to set up a loop within my INSERT statement so that I don’t have to write it like:

$query = “INSERT INTO column (col1, col2, col3,…) VALUES (val1, val2, val3,…)”;

Thanks a lot.