如果其中一个列属性为true，则设置表格行的样式

I'm filling an HTML table with data from the following query:

$content_downloads = mysql_query( "SELECT 
     s.site, s.machine, d.projectid, d.directorySize, d.connectivityError, 
     d.blocked, d.blockedBy, d.blockedSince, d.errorString, d.dashboardTimeStamp 
     FROM rtcdb.site_machines s 
     LEFT JOIN rtcdb.downloadstatuses d 
     on (s.site = d.site and s.machine = d.machine)             
     where s.site in (select d2.site from rtcdb.downloadstatuses d2 
     where  d2.dashboardTimeStamp > (SELECT DATE_ADD(max(dashboardTimeStamp),INTERVAL -1 DAY)  
     from rtcdb.downloadstatuses)) order by s.site, s.machine asc", $con) or die(mysql_error());

This query is going into an HTML table based on the following HTML/PHP:

            <table>
                <thead>
                    <tr>
                        <th>Site</th>
                        <th>Machine</th>
                        <th>Project ID</th>
                        <th>Folder Size</th>
                        <th>Error Description</th>
                    </tr>
                </thead>

                <tbody>
                    <?php
                        while ($row = mysql_fetch_assoc($content_downloads)) {
                            $error_string = "";
                            if ($row["connectivityError"] == true ) {
                                $error_string = "COULD NOT CONNECT: " . $row["errorString"];
                            }
                            elseif ($row["blocked"] == true ) {
                                $error_string = "BLOCKED BY LOCK OWNED BY: " . $row["blockedBy"] . " " . $row["blockedSince"];
                            }

                            echo '
                                <tr>
                                    <td>'.$row["site"].'</td>
                                    <td>'.$row["machine"].'</td>
                                    <td>'.$row["projectid"].'</td>
                                    <td>'.$row["directorySize"].'</td>
                                    <td style = "text-align: left; color: red;">'.$error_string.'</td>
                                </tr> ';
                            }
                        ?>
                </tbody>
        </table>

The error description column in this table rarely has contents. As you can see, when it does, a PHP conditional function (the if and ifelse functions) places a statement before the error description to make the description more understandable. One thing you may notice is that I am coloring the text of error descriptions red. The thing that I am struggling with that I need your help on is to selectively style an entire row with a background-color of yellow, when the error description cell in that row has a value. In other words, when the two conditionals I wrote are true, I would like to make the background-color of the row that includes that error description yellow.

It seems pretty simple, but I have tried various options and can't seem to figure it out. Any tips Stack Overflow?

Check if the error string is empty:

echo '
    <tr' . (empty($error_string) ? '' : ' style="background-color:yellow;"') . '>
        <td>'.$row["site"].'</td>
        <td>'.$row["machine"].'</td>
        <td>'.$row["projectid"].'</td>
        <td>'.$row["directorySize"].'</td>
        <td style = "text-align: left; color: red;">'.$error_string.'</td>
    </tr> ';

What I would try is setting a class on the row of interest:

<tr class="highLight">

and then use CSS to set the background color of the cells in that row:

tr.highLight td {background-color: yellow; }

Set the class attribute is your error string has content.

Try this:

if($error_string != "")
 {
   echo '<tr class="error-row"';
 }else{
   echo '<tr>';
 }
 echo    '<td>'.$row["site"].'</td>
         <td>'.$row["machine"].'</td>
         <td>'.$row["projectid"].'</td>
         <td>'.$row["directorySize"].'</td>
         <td style = "text-align: left; color: red;">'.$error_string.'</td>
         </tr> ';

and add this to your stylesheet:

.error-row{background:yellow;}

if you want less code you can use the if shorthand too like this:

echo   '<tr' . ($error_string == "" ? '' : 'class="error-row"') . '>
          <td>'.$row["site"].'</td>
          <td>'.$row["machine"].'</td>
          <td>'.$row["projectid"].'</td>
          <td>'.$row["directorySize"].'</td>
          <td style = "text-align: left; color: red;">'.$error_string.'</td>
        </tr> ';

Ok, I figured out what to do, and I apologize for not using jQuery or class attributes. I appreciate everyones help, and am being honest when I say that everyone's comments and answers helped me figure it out. Here's the solution:

                            if ($error_string != ""){
                                echo '
                                    <tr style = "background-color: yellow;">
                                        <td>'.$row["site"].'</td>
                                        <td>'.$row["machine"].'</td>
                                        <td>'.$row["projectid"].'</td>
                                        <td>'.$row["directorySize"].'</td>
                                        <td style = "text-align: left; color: red;">'.$error_string.'</td>
                                    </tr> ';
                                }
                            else {
                                echo '
                                    <tr>
                                        <td>'.$row["site"].'</td>
                                        <td>'.$row["machine"].'</td>
                                        <td>'.$row["projectid"].'</td>
                                        <td>'.$row["directorySize"].'</td>
                                        <td style = "text-align: left; color: red;">'.$error_string.'</td>
                                    </tr> ';
                                }

Thanks for everyone's help!