i need help php and sql script

[Lock Down]

This code is working thank you

The color can be changed on the whole row? PPM Due Date is just the text color is changed

You are welcome..

For the text in the whole row..

change

                                                echo " <td>" . $row->dateinsrep . "</td>";  
                                                echo "<td>" . $row->servicereport . "</td>";  
                                                echo "<td>" . $row->hospitalname . "</td>";  
                                                echo "<td>" . $row->description . "</td>";  
                                                echo "<td>" . $row->model . "</td>";  
                                                echo "<td>" . $row->serial . "</td>";  
                                                echo "<td>" . $row->dinstall . "</td>";  
                                                echo "<td>" .$date  ."</td>";  
                                                echo "<td>" . $row->warranty . "</td>"; 

to

                             echo $colorPrefix . " <td>" . $row->dateinsrep . "</td>";   
                                                echo "<td>" . $row->servicereport . "</td>";   
                                                echo "<td>" . $row->hospitalname . "</td>";   
                                                echo "<td>" . $row->description . "</td>";   
                                                echo "<td>" . $row->model . "</td>";   
                                                echo "<td>" . $row->serial . "</td>";   
                                                echo "<td>" . $row->dinstall . "</td>";   
                                                echo "<td>" .$date  ."</td>";   
                                                echo "<td>" . $row->warranty . "</td>". $colorSuffix;