changing font color based on database value

[ckwall]

Is it possible to change the color of the text in a found record based on the value of one field?

For example if the record selected from the database has a field name of priority and I want all of the records that where priority = 1 to have red text. Priority 2 blue... etc.

Here is what I am doing currently:

$query="SELECT * FROM request order by assigned_priority"; 
$result=mysql_query($query); 

$num=mysql_numrows($result); 

mysql_close(); 

echo "<b><center>New Requests</center></b><br><hr><br>"; 

$i=0; 
while ($i < $num) { 
//Tracker Values 
$ticket_num=mysql_result($result,$i,"ticket_num"); 
$priority=mysql_result($result,$i,"assigned_priority"); 
$first_name=mysql_result($result,$i,"first_name"); 
$last_name=mysql_result($result,$i,"last_name"); 
$department=mysql_result($result,$i,"department"); 
$ext=mysql_result($result,$i,"ext"); 
$email=mysql_result($result,$i,"email"); 
$summary=mysql_result($result,$i,"summary"); 
$details=mysql_result($result,$i,"details"); 
$day=mysql_result($result,$i,"day"); 
$month=mysql_result($result,$i,"month"); 
$year=mysql_result($result,$i,"year");
$assigned_1=mysql_result($result,$i,"assigned_1");
$assigned_2=mysql_result($result,$i,"assigned_2");
$assigned_3=mysql_result($result,$i,"assigned_3");
$assigned_4=mysql_result($result,$i,"assigned_4");
$approval=mysql_result($result,$i,"approval");


echo " 

<table width=80%>
<tr><td>
<b>Ticket Number $ticket_num</b><br> 
Assigned Priority: $priority <br> 
Name: $first_name $last_name <br> 
Department: $department <br> 
Extension: $ext <br> 
Email: $email <br> 
Request Summary: $summary <br> 
Request Details: $details <br> 
Requested Due Date: $day/$month/$year <br>
Assigned to: $assigned_1, $assigned_2, $assigned_3, $assigned_4<br>
Arrpoved: $approval<br>
</td>
<tr>
</table>

<hr>
"; 

++$i; 
} 

?>

[tryton]

I would think fairly simple, just have an if statement checking the priority and then for each priority have it echo a font color, for example:

if($priority==2){ echo "<font color=\"FF0000\">"; }
else if ($priority==3){ echo "<font color=\"0000FF\">"; }
else if *and so on*
<b>Ticket Number $ticket_num</b><br> 
Assigned Priority: $priority <br> 
Name: $first_name $last_name <br> 
Department: $department <br> 
Extension: $ext <br> 
Email: $email <br> 
Request Summary: $summary <br> 
Request Details: $details <br> 
Requested Due Date: $day/$month/$year <br> 
Assigned to: $assigned_1, $assigned_2, $assigned_3, $assigned_4<br> 
Arrpoved: $approval<br> 
</font>