we have created a table (6×2) with column 2 containing a FA circle followed by a database field (environment in the example below) which contains the value (Outstanding, Very Good, Good, Needs Improvement & Adequate).
I need to be able to change the colour of the fa-circle (traffic light colours) depending on the value of field that is in that line.
How best to achieve this please?
</h2>
<table class="tableag" style="width: 80%;">
<tbody>
<tr>
<td style="width: 40.0000%;background-color: #ffffff;color: #f2a34f;border-top: 3px solid #ffffff;
border-left: 3px solid #ffffff;"><b>Category</b></td>
<td style="width: 60.0000%;background-color: #ffffff;color: #f2a34f;border-top: 3px solid #ffffff;
border-left: 3px solid #ffffff;"><b>Rating</b></td>
</tr>
<tr>
<td style="width: 40.0000%;">Overall<br></td>
<td style="width: 60.0000%;background-color: #ffffff;color: #000000; class = "outcome"; "><i class="fa fa-circle" aria-hidden="true"></i> <br><?php echo $user['rating']?></td>
</tr>
<tr>
<td style="width: 40.0000%;">Care & Support<br></td>
<td style="width: 60.0000%;background-color: #ffffff;color: #000000;class = "outcome";"> <i class="fa fa-circle" aria-hidden="true"></i> <br><?php echo $user['care_and_support']?></td>
</tr>
<tr>
<td style="width: 40.0000%;">Environment<br></td>
<td style="width: 60.0000%;background-color: #ffffff;color: #000000;class = "outcome";"><i class="fa fa-circle" aria-hidden="true"></i> <br><?php echo $user['environment']?></td>
</tr>
<tr>
<td style="width: 40.0000%;">Leadership<br></td>
<td style="width: 60.0000%;background-color: #ffffff;color: #000000;class = "outcome";"><i class="fa fa-circle" aria-hidden="true"></i> <br><?php echo $user['leadership']?></td>
</tr>
<tr>
<td style="width: 40.0000%;">Staff & team</td>
<td style="width: 60.0000%;background-color: #ffffff;color: #000000;class = "outcome";"><i class="fa fa-circle" aria-hidden="true"></i> <br><?php echo $user['staff_team']?></td>
</tr>
<tr>
<td style="width: 40.0000%;">Wellbeing<br></td>
<td style="width: 60.0000%;background-color: #ffffff;color: #000000;class = "outcome";"><i class="fa fa-circle" aria-hidden="true"></i> <br><?php echo $user['wellbeing']?></td>
</tr>
<tr>
<td style="width: 40.0000%;">Full report<br></td>
<td style="width: 60.0000%;background-color: #ffffff;color: #000000;"><a class="btn btn-warning btn-rg" href=<?php echo $user['cqc_url_report_english']?> target="_blank">Full Report</a></td>
</tr>
</tbody>
</table>