Setting dynamic links to a speciffic colour
Hi,
I posted this initially under dataAssist and then realised it was in the wrong place, so no spamming was intended, I promise.
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