note
roboticus
<p>[jason.c.rochon]:</p>
<p>You don't *have* to use arrays. But it really depends on the result(s) you want. If you want all three comments to be tied to the same key, you could read your data like:</p>
<c>
my $sth=$dbh->prepare("select ....");
$sth->execute;
# Stuff all the data in a hash, concatenating all comments
my %Macs;
while (my $hr = $sth->fetchrow_hashref) {
if (! exists $Macs{$$hr{mac}}) {
$Macs{$$hr{mac}} = $$hr{comment};
}
else {
$Macs{$$hr{mac}} .= $$hr{comment};
}
}
</c>
<p>You could have each hash key hold an array of comments, too. It all boils down to how you're actually going to work with the data.</p>
<p>...[roboticus]</p>
<p><i>When your only tool is a hammer, all problems look like your thumb.</i></p>
1004111
1004111