如何在php中根据相同的值设置表tr背景颜色

Question

how can i set the table tr background color according to same value in one row ?

<?php 
 $result = mysql_query("SELECT * FROM `status` where username ='".$UserName."' ",$conn);
while($row=mysql_fetch_array($result))
{
echo '
    <tr style="'.$bgcolor.'">
        <td>
        '.$row["Uv"].'
        </td>
        <td>
        '.$row["Su"].'
        </td>
        <td> '.$row["Status"].' </td>
    </tr> ';
}
?>

How the rows should look like i wan't change color according to same uv like hmsid20161812(blue color), hmsid20161815(brown color), hmsid20161810 (yellow color) means we give color code or name in array but print according to uv.

Answer 1

You need to add background-color: attribute of css before colour.

Change

<tr style="'.$bgcolor.'">

with

<tr style="background-color: '.$bgcolor.'">