<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">2015-09-30 14:25 GMT-05:00 WK <span dir="ltr"><<a href="mailto:wanradt@gmail.com" target="_blank">wanradt@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi!<br>
<span class=""><br>
2015-09-30 22:20 GMT+03:00 Richard Reina <<a href="mailto:gatorreina@gmail.com">gatorreina@gmail.com</a>>:<br>
<br>
> Matched_pats.keys.sort %>. However, In this case though the template only<br>
> displays one row because each resulting row in the SQL query all have the<br>
> same ID number. Is there any simple change I can make to get the results to<br>
> fully iterate?<br>
<br>
</span>How could you have hash(ref), where are multiple keys named by same ID?<br>
<br>
Could you show your datastructure?<br>
<br></blockquote></div>Â Â $q = 'SELECT l.ID, <br>Â Â Â Â Â Â Â Â c.ID AS CHLG_ID, c.season, c.YEAR, <br>Â Â Â Â Â Â Â Â g.date, g.opp_team, <br>Â Â Â Â Â Â Â Â a.NAME AS ANAME, <br>Â Â Â Â Â Â Â Â ch.NAME AS CHNAME, <br>Â Â Â Â Â Â Â Â p.AMOUNT, <br>Â Â Â Â Â Â Â Â u.screenname AS SPONSOR <br>Â Â Â Â Â Â Â Â FROM game g, accomp_type a, logro l <br>Â Â Â Â Â Â Â Â LEFT JOIN challenge c ON l.ACC_TYPE_ID=c.ACC_TYPE_ID <br>Â Â Â Â Â Â Â Â LEFT JOIN patrocinio p ON c.ID=p.CHLNG_ID <br>Â Â Â Â Â Â Â Â LEFT JOIN charity ch ON c.CHAR_ID=ch.ID <br>Â Â Â Â Â Â Â Â LEFT JOIN patron pn ON p.PTRN_ID=pn.ID <br>Â Â Â Â Â Â Â Â LEFT JOIN usuario u ON pn.USER_ID=u.ID <br>Â Â Â Â Â Â Â Â WHERE l.GAME_ID=?<br>Â Â Â Â Â Â Â Â AND l.status=? <br>Â Â Â Â Â Â Â Â AND g.ID=l.GAME_ID <br>Â Â Â Â Â Â Â Â AND YEAR(g.DATE)=c.YEAR <br>Â Â Â Â Â Â Â Â AND MONTH(g.date) IN (?, ?, ?)<br>Â Â Â Â Â Â Â Â AND l.ACC_TYPE_ID=a.ID';<br>Â Â Â Â Â Â Â Â <br>$sth = $dbh->prepare($q);<br>Â Â Â Â Â Â Â Â $sth->execute($self->{_game_id}, $self->{_logro_status}, @$season_mo[0], @$season_mo[1], @$season_mo[2]);<br>Â Â Â Â Â Â Â Â my $pats_ref = $sth->fetchall_hashref('ID');<br>Â Â Â Â Â Â Â Â Â <br></div></div>