I am struggling with how to highlight a row when Column F displays a value of F. I understand that I can achieve this using CSS/JS, but I keep hitting a roadblock. Coding is new to me, so I would greatly appreciate some assistance if possible.
Objective: I need the entire row to be highlighted in yellow when Column F shows a value of F.
Thank you for your help in advance!!!
<div class='row'>
<div class='col-lg-12 col-sm-12'>
<div class='panel panel-primary'>
<div class='panel-heading'>
<h3 class='panel-title'><i class='fa fa-bar-chart-o'></i>Priority Lots</h3>
</div>
<table class='table'>
<thead>
<tr>
<th>LOT</th>
<th>LPT</th>
<th>OPN</th>
<th>DEVICE</th>
<th>QTY</th>
<th>DTTM</th>
<th>I</th>
<th>H</th>
<th>F</th>
<th>P</th>
<th>S</th>
<th>LOCATION</th>
<th>STATUS</th>
<th>EQUIP</th>
</tr>
</thead>
</div>
$sqlstr="select l.lot, l.lpt, lc.opn, ls.device, l.cur_qty as qty,
round((sysdate - l.last_act_dttm)*24,1) as dttm,
l.isc as i, l.hold as h, l.ftr_hold as f, ls.priority as p,
ls.swr as s, ls.lot_code3 as location,
decode (lc.lot_status,'P',' Processing ') as status, lc.equip
from lot l, lot_str ls, lot_cur_opn lc, lpt_grp_lpt_lst lg
where l.facility = 'DP1DM5' and lc.facility = l.facility
and ls.facility = l.facility and lg.lpt_grp_facility = 'DP1DM5'
and l.lot = ls.lot and l.lot = lc.lot
and ls.latest = 'Y' and ls.priority != 'N'
and ls.priority IN ('0','1','2','3')
and l.lpt < 'TRM' and ls.latest = 'Y' and l.lpt = lg.lpt
and lg.lpt_grp_type = 'G' and lg.lpt_grp = '3005'
order by p, lpt
";
$sth = $dbh->prepare($sqlstr);
$sth->execute();
$sth->bind_columns(undef, \$LOT, \$LPT, \$OPN, \$DEVICE, \$QTY, \$DTTM, \$I, \$H, \$F, \$P, \$S, \$LOCATION, \$STATUS, \$EQUIP);
while($sth->fetch()) {
print "
<tbody>
<tr class='row100 body'>
<td class='cell100 column4'>$LOT</td>
<td class='cell100 column4'>$LPT</td>
<td class='cell100 column4'>$OPN</td>
<td class='cell100 column4'>$DEVICE</td>
<td class='cell100 column4'>$QTY</td>
<td class='cell100 column4'>$DTTM</td>
<td class='cell100 column4'>$I</td>
<td class='cell100 column4'>$H</td>
<td class='cell100 column4'>$F</td>
<td class='cell100 column4'>$P</td>
<td class='cell100 column4'>$S</td>
<td class='cell100 column4'>$LOCATION</td>
<td class='cell100 column4'>$STATUS</td>
<td class='cell100 column4'>$EQUIP</td>
</tr>";
}
print "</tbody>
</table>
</div>
<BR>
<BR>
</div>
Check out this screenshot of column F: