Row Color Question

[Titan85]

Ok, I am making a script for support tickets, and I want the cell that has the ticket status (low, medium, high, urgent) in it to show up a different color depending on its urgency. I am trying to do this by using the urgency column from the sql table. Here is how I am trying to do it:
// For each result found
while($row = mysql_fetch_array($result)) {
extract($row);

echo '
<tr>
<td>'.$id.'</td>
<td><a href="index.php?page=view&id='.$id.'">'.$subject.'</a></td>
<td style="background-color: '.$color.'">'.$urgency.'</td>
<td>'.$date.'</td>
<td><input type="checkbox" name="checkbox[]" value="'.$id.'" /></td>
<td>'.$status.'</td>
</tr>';

// Get status color
if($urgency == "low") {
$color == "#F19F00";
}
if($urgency == "medium") {
$color == "#EC7501";
}
if($urgency == "high") {
$color == "#EC3801";
}
if($urgency == "urgent") {
$color == "#FF0000";
}
}I am not sure if that way will work correctly or not, but as of now the color does not show up. I appreciate any help :)

[mburt]

I'm assuming you haven't defined all of your variables for the rows, and that's probably why it won't work:

Make sure you define them:

id might be

$id = mysql_result($result,$i,"id");
and do that with the other undefined variables.
For that to work you must use an iterator in your while loop:


$i = 0;
while($row = mysql_fetch_array($result)) {
extract($row);

echo '
<tr>
<td>'.$id.'</td>
<td><a href="index.php?page=view&id='.$id.'">'.$subject.'</a></td>
<td style="background-color: '.$color.'">'.$urgency.'</td>
<td>'.$date.'</td>
<td><input type="checkbox" name="checkbox[]" value="'.$id.'" /></td>
<td>'.$status.'</td>
</tr>';

// Get status color
if($urgency == "low") {
$color == "#F19F00";
}
if($urgency == "medium") {
$color == "#EC7501";
}
if($urgency == "high") {
$color == "#EC3801";
}
if($urgency == "urgent") {
$color == "#FF0000";
}
i++;
}

[thetestingsite]

Actually, if you just want to make the row color based upon what the urgency is, you don't need anything special other than the code snippet below:




while($row = mysql_fetch_array($result)) {
extract($row);


// Get status color
if($urgency == "low") {
$color == "#F19F00";
}
if($urgency == "medium") {
$color == "#EC7501";
}
if($urgency == "high") {
$color == "#EC3801";
}
if($urgency == "urgent") {
$color == "#FF0000";
}


echo '
<tr>
<td>'.$id.'</td>
<td><a href="index.php?page=view&id='.$id.'">'.$subject.'</a></td>
<td style="background-color: '.$color.'">'.$urgency.'</td>
<td>'.$date.'</td>
<td><input type="checkbox" name="checkbox[]" value="'.$id.'" /></td>
<td>'.$status.'</td>
</tr>';

}


Notice how I define the color variable before I display the information.

Hope this helps.

[Titan85]

I tried both ways and both were unsuccessful. It just doesn't get the color value. Any ideas?

[thetestingsite]

I just noticed (sorry, my daughter woke me up extremely early this morning) the following part



$color == "#F19F00";


should be


$color = "#F19F00";


Notice one equal sign ( = )

That should do it

[Titan85]

The = sign was it! Thanks a ton. Howcome the double "=" was making it mess up?

[thetestingsite]

When you use double equal signs, it means you are comaring something:



if ($urgency == "low")


That compares the value of urgency to something else ("low"). A single equal sign defines something:



$color = #000000;


Hope that helps.

[mburt]

Ah yes, a common mistake to overlook the to operators.
== is a comparison operator
= is an assigning operator
=== assigns/compares the string/number based on the result

[Titan85]

Thanks for the help, its working great :)