formatting numbers in different colors

[blackholesun]

Hi all,

 

If anyone can offer any advice on the following, that would be great... I've been running round in circles on the internet trying to find this answer but am having no success...

 

All i want to be able to do is to format a MySQL query result so that a negative number is red and a positive number is blue. So far, the query runs fine, the results are displayed largely in the format i want, i am just trying to do this one last refinement. I'm thinking something along the lines of:

if($row['number'] < 0){
//display red
}else{
//display blue
}

...but what i have attempted with that conditional will not write to the table output. I'm probably barking up the wrong tree with the if..else conditional but am still new to php so am having trouble coming up with the right solution. So, is there a way of doing this just with php? Or am I going to have to use something else?

 

Any help/info greatly appreciated

Edited May 16, 2013 by blackholesun

[cpd]

if(($id % 2) == 0) 
    echo '<td class="red">';
else
    echo '<td class="blue">';

[blackholesun]

if(($id % 2) == 0) 
    echo '<td class="red">';
else
    echo '<td class="blue">';

Is the '$id' in your example the same as the $row['number'] in mine?

Edited May 16, 2013 by blackholesun

[cpd]

You've used $row['number']; so assuming that's what you meant and this is a uniquely identifying integer for the record then yes.

[akphidelt2007]

I usually do this like this

 

 

if($row['result'] > 0)
   $color = 'blue';
elseif($row['result'] < 0)
   $color = 'red';
else
   $color = 'black;
 
echo "<span style='color:$color;'>{$row['result']}</span>";

[akphidelt2007]

Or if you want 0 to blue you can do the shortcut...

 

 

$color = $row['result'] < 0 ? 'red' : 'blue';
 
echo "<span style='color:$color;'>{$row['result']}</span>";

[blackholesun]

Brilliant! Thanks both for the replies, they were most helpful

 

 

Problem solved!