dongsheng8664 2012-05-09 22:04
浏览 28
已采纳

.addClass,基于值的IF语句

I am trying use an if statement and TWO .addClass background-color variables based on whether the column value for 'shift_times'= "SAT AM/SUN PM" or = "SAT PM/SUN AM". I am finding solutions for when a value is a number, but not text.

     $query = "SELECT COUNT(confirmed) as cnt, 
     position, shift_times 
     FROM volConfirm 
     WHERE confirmed='yes'  
     GROUP BY shift_times, position
     order by position"; 

     $result = mysql_query($query) or die(mysql_error());


     while($row = mysql_fetch_array($result))
      {
      echo "<tr>";
  echo "<td>" . $row['position'] ." ". $row['shift_times'] ."= " . $row['cnt'] . "</td>";
  echo "</tr>";
       }
  • 写回答

2条回答 默认 最新

  • dongshi7433 2012-05-09 22:42
    关注

    Is something like this what you were looking for?

    $query = "SELECT
          COUNT(confirmed) as cnt, 
          position,
          shift_times 
       FROM volConfirm 
       WHERE confirmed='yes'  
       GROUP BY shift_times, position
       ORDER BY position"; 
    
    $result = mysql_query($query) or die(mysql_error());
    
    
    while($row = mysql_fetch_array($result)) {
       if ($row['shift_times'] === 'SAT AM/SUN PM') {
          echo '<tr class="class1">';
       } else if ($row['shift_times'] === 'SAT PM/SUN AM') {
          echo '<tr class="class2">';
       } else {
          echo '<tr>';
       }
       echo "<td>" . $row['position'] ." ". $row['shift_times'] ."= " . $row['cnt'] . "</td>";
       echo "</tr>";
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?