Setting dynamic links to a speciffic colour

Hi,

I wonder if any one can help me? I use dataAssist and its a great extension to dreamweaver. Most of my pages are generated with some form of dataAssist code embed in it.

I have a php/mysql page that displays a list of house numbers, for example 1 to 10 that require work completing;

There is a case where some of these house numbers have already had the work completed, but will require inspection of the completed work.

Its been suggested to me that I should set the house numbers (font colour) to red or purple if they require inspection. This simple effect will visually inform the workers that they dont need to look at that record because the work has been completed. But, will inform the inspectors to look at the record and fill in the relevant details.

I am able to perform the search for property numbers, but depending on the sql code (inspect_property=1) set the property number to the correct colour otherwise leave it at the default colour.

here is the code
______________________________________________________________________

<?php echo $row_Recordsetdisplayproperties['cust_houseno']; ?></a>
<?php } while ($row_Recordsetdisplayproperties = mysql_fetch_assoc($Recordsetdisplayproperties)); ?>
______________________________________________________________________

Hope that helps, but if you need more information I am happy to oblige

thanks

John