[SOLVED] Mysql php colour conditional format....

[anilvaghela]

Hello there guys n girls....

 

This one is something of something i need help on...

 

I have a table which has the following columns.

 

namechannel  = values = varchar

agg              = values = 1 or 0

pseudo        = values = 1 or 0

 

now what i want to do in php is to list all the namechannels and say for example:

 

one row = namechannel and also agg = 1  ( i want the namechannel to be blue)

one row = namechannel and also pseudo = 1 ( i want the namechannel to be green)

one row = namechannel and also pseudo and agg = 0 ( i want the namechannel to be red)

 

 

I have had a look about but cant find the functionality for this and would really would appreciate some help on this please.

 

Thanks!

 

Anil Vaghela

[aschk]

In pseudocode...

 

if(agg==1) {
$color = blue
} elseif(pseudo == 1){
$color = green
} elseif(agg == 0 AND pseudo == 0){
$color = red
}

 

 

[anilvaghela]

Thanks but how do i build it into a sql script to show the results in php?

[anilvaghela]

This is what i did.....

 

 

<table border="1" >

  <tr>

   

    <td><div align="center" class="style3">Name Ch</div></td>

<td><div align="center" class="style3">Level</div></td>

  </tr>

  <?php do {

  if ($row_channels['level']=="-1") { $SPACE="";}

  if ($row_channels['level']=="0") { $SPACE="--";}

  if ($row_channels['level']=="1") { $SPACE="----";}

  if ($row_channels['level']=="2") { $SPACE="------";}

  if ($row_channels['level']=="3") { $SPACE="--------";}

  if ($row_channels['level']=="4") { $SPACE="----------";}

  if ($row_channels['level']=="5") { $SPACE="------------";}

//else { $SPACE="";}

 

//$agg = $row_channels['agg'];

//$pseudo = $row_channels['pseudo'];

//$site = $row_channels['site'];

 

 

  if($row_channels['agg']=="1") { $color = "blue"; }

  if($row_channels['pseudo'] == "1"){ $color = "green"; }

  elseif($row_channels['agg'] == "0" AND $row_channels['pseudo'] == "0"){ $color = "red";}

else {$color = "black";}

  ?>

  <tr>

      <td><span class="style3" style="color:<?=$color?>"><?php echo $SPACE.''.$row_channels['name_ch']; ?></span></td>   

<td><span class="style3" style="color:<?=$color?>"><?php echo $row_channels['level'];?></span></td>

  </tr>

 

  <?php } while ($row_channels = mysql_fetch_assoc($channels)); ?>

</table>