Re: MySQL hashes with same key

[roboticus]

in reply to MySQL hashes with same key

jason.c.rochon:

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:

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};
    }
}

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.

...roboticus

When your only tool is a hammer, all problems look like your thumb.

[jason.c.rochon]

Thank you for your response. I would like to print out a list of comments for one address. If I search for mac aaaa.aaaa.aaaa.aaaa Printout Mac: aaaa.aaaa.aaaa.aaaa Comments: filtered for virus filtered by dmca filtered for excessive bandwidth filter on spoofed mac Thanks again.