# SQL: loop within INSERT statement

**URL:** <https://forum.kirupa.com/t/sql-loop-within-insert-statement/129257>\
**Category:** Uncategorized\
**Created:** [November 21, 2004, 7:22pm UTC](https://forum.kirupa.com/t/sql-loop-within-insert-statement/129257 "2004-11-21T19:22:21Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Flashmatazz](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/flashmatazz/32/140_2.png) [@Flashmatazz](https://forum.kirupa.com/u/Flashmatazz)\
**Post date:** [November 21, 2004, 7:22pm UTC](https://forum.kirupa.com/t/sql-loop-within-insert-statement/129257/1 "2004-11-21T19:22:21Z")

</div>

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.