What is the easiest way to have this sort by the backround color?
$sql = mysql_query("SELECT * FROM $catagory$subcatagory WHERE HOLD LIKE 'Y' AND ACTIVE LIKE 'N' AND FOLLOWUPCONTACT LIKE 'Y' AND FOLLOWUP2 = '0' ORDER BY SERVICEDATE DESC");
if(mysql_num_rows($sql) == 0){
echo "<font color='#000066' size='3' face='Verdana, Arial, Helvetica, sans-serif'>No Follow-Ups to View at this time.</font>";
}else{
while($row = mysql_fetch_array($sql)){
$print = $row["PRINT"];
if ($print == '0'){
$bgcolor = "#FFFFFF";
}else{
$bgcolor = "#E0E0E0";
}
print "......
Thanks in advance