03-13-2014,Bob Jones,Pending
03-13-2014,George Manuel,Pending
03-13-2014,Frankie Avalon,Approved
03-13-2014,Robert Garcia,Approved
03-14-2014,John Doe,Pending

##</code><code>##

$sth = $dbh->prepare(
            " 
                SELECT date,name,status
                FROM requests 
                WHERE date >= '$date' 
                ORDER BY date
            "
        );
        $sth->execute();
        my $reqs;
        push @{$reqs}, $_ while $_ = $sth->fetchrow_hashref();

##</code><code>##

my $template = HTML::Template->new(filename => 'approve.html');
$template->param(REQS => $reqs);
print $template->output();


##</code><code>##

<form>
	<table class=approve>
		<tr>
			<th class=approve>Approve</th>
			<th class=approve>Decline</th>
			<th class=approve>Date</th>
			<th class=approve>Name</th>
			<th class=approve>Status</th>
		</tr>
		<TMPL_LOOP NAME=REQS>
				<tr class=approve>
					<td class=approve><input type=radio name=approve value=Approved></td>
					<td class=approve><input type=radio name=decline value=Declined></td>
					<td class=approve>
						<span class="hotspot" onmouseover="tooltip.show('<strong>Approved Vacation Requests</strong><br /><TMPL_VAR DATE>');" onmouseout="tooltip.hide();">
							<TMPL_VAR NAME=DATE>
						</span>
					</td>
					<td class=approve><TMPL_VAR NAME=NAME</td>
					<td class=approve><TMPL_VAR NAME=STATUS</td>
				</tr>
			</TMPL_IF>
		</TMPL_LOOP>
		<tr class=approve>
			<th class=approve colspan=6>
				<input type=submit value="Approve / Decline">
				<input type=hidden value=approve name=state>
			</th>
		</tr>
	</table>
</form>
<script type="text/javascript" language="javascript" src="js/script.js"></script>

##</code><code>##

						<span class="hotspot" onmouseover="tooltip.show('<strong>Approved Vacation Requests</strong><br /><TMPL_VAR DATE>');" onmouseout="tooltip.hide();">

##</code><code>##

{
   '03-13-2014' => 'Frankie Avalon,Robert Garcia',
};