Link to home
Start Free TrialLog in
Avatar of Caxxcann
Caxxcann

asked on

How to format numbers on a recordset

How do I set a negative number to a red color from a recordset retrived from:

Select table1.ID, table1.Name, Sum(Case When table1.ID = table2.ID and  table2.score1 < 0 Then score1 Else 0 End)
From table1, table2
ASKER CERTIFIED SOLUTION
Avatar of Xorlev
Xorlev
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Matthew Kelly
Matthew Kelly
Flag of United States of America image
It isn't a mysql database that you are selecting from I can tell, but if you were the code below would be what it is.

This would set the bg color to red, but the same concept could be set for the font as well.

You will need to change the mysql syntax to the MSSQL or Access that you are using
$sql = "Select table1.ID, table1.Name, Sum(Case When table1.ID = table2.ID and  table2.score1 < 0 Then score1 Else 0 End)
From table1, table2";
$result = mysql_query($sql,$db);
if ($result && mysql_num_rows($result) > 0 )
{
	echo "<table cellpadding=0 cellspacing=0>";
	for ($i=0;$i<mysql_num_rows($result);$i++)
	{
		$id = mysql_result($result,0,"ID")
		$name = mysql_result($result,0,"Name")
		$score = mysql_result($result,0,2);
		if ( $score < 0 )
		{
			echo "<tr style=\"background-color:red\">";
		}
		else { echo "<tr>"; }
 
		echo "<td>".$id."</td><td>".$name."</td><td>".$score."</td>";
		
		echo "</tr>";
	}
	echo "</table>";
}

Open in new window