Russ's solution seems to accomplish this by having the MySQL insert the records one at a time. I know MySQL has a feature that let's you do an Insert of multiple rows with one statement.
How do you accomplish that.
Comment on Re: How can I allow the user to enter multiple rows of data?
I didn't find any way to insert multiple rows at once, other
than the LOAD DATA INFILE syntax.
Note: I am running an archaic version of MySQL, just like
the old 5.005_57 version of Perl, because I am too lazy to
keep it up-to-date. If there is a newer, better way in the
recent versions, feel free to post it. I'd love to know
about it. :-)
Russ
Brainbench 'Most Valuable Professional' for Perl