Hi typomaniac. Your code doesn't compile, because you're just pasting chunks from your script. Eg:

my %medals=(
"$med1"=>"$me1",
"$med2"=>"$me2",
"$med3"=>"$me3",

my $table="table";
[download]

Please post actual working code, with use strict; and use warnings; enabled. Then we'll be able to help more easily! See How do I post a question effectively?

Edit:
Also, here's a couple of observations.

• You should use $dbh->prepare outside a loop and then use $dbh->execute inside the loop with the bind values. Your code prepares the statement handle each time through the loop; the whole point of prepare() is so you only have to do it once.
• You use LAST_INSERT_ID() each time you execute the statement handle as one of the bind values, but you don't do any (more) inserts. If what you really want is the same value for that column in each row, get it before you prepare the statement handle (once) and put it in the SQL.

Hope this helps!

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.