The only comment I would add on this is that what you will do may slow your program down. I mean if you execute a query inside a loop that has say 100,000 records, you'll be executing a query 100,000 time inside that loop.

If the second query will be referencing the same index in a table, I would recommend creating a hash for the entire second dbi execute prior to executing the first query and performing the loop. This way, you're simply reference the hash for the value instead of performing all those queries. This may not work for what you need, but I thought it would be worth noting.

example:

## ASSUMED CONNECTION ESTABLISHED ##

# CREATE HASH FOR REFERENCE
$sth = $dbh->prepare("select report_id, name from reportindex");
$sth->execute();
while ($ref = $sth->fetchrow_hashref()) {
    $reportIndex{"R$ref->{'report_id'}"} = $ref->{'name'};
}
$sth->finish() unless (! $sth);

$sth = $dbh->prepare("select reportindex_id from favorite_reports");
$sth->execute();

while ($ref = $sth->fetchrow_hashref()) {
    # REFERENCE HASH INSTEAD OF CALLING SECOND QUERY
    print "I like the report: ". $reportIndex{"R$ref->{'reportindex_id
+'}"}; 
}

$sth->finish() unless (! $sth);
[download]

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.