colouring a row in a dynamic table

[timgarratt]

How do I set a colour for a row in a dynamic table based on a mysql query from a field called colour?
Best Regards,
Tim

[scrupul0us]

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "<tr style=\"background-color: ".$row['colour'].";\">";
echo $row['data'];
echo "</tr>";
}