http://www.perlmonks.org?node_id=26597


in reply to Re: How can I allow the user to enter multiple rows of data?
in thread How can I allow the user to enter multiple rows of data?

I thought I would offer a little more cleaned up version. Cuz I have had to do this before.
for (1..10){ # using one var and letting CGI handle it print qq{ <tr> <td><input type="text" name="stuff"></td> </tr> }; } # In your script that receives the POST use CGI; my $cgi = new CGI; my @stuff = $cgi->param('stuff'); foreach my $thing (@stuff){ "INSERT INTO STUFF_HOLDER VALUES('$thing')"; }
BTW. The only other way I know how to INSERT more than one row into a table with a single SQL statement is by complimenting the INSERT with a SELECT. For example: INSERT INTO new_table SELECT * FROM old_table