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>";
}