PHP Forum

**beylah** · 10:26 AM

I am trying to assign a font color red when the value is 'red', yellow when the value is 'yellow', green when the value is 'green' and blue when the value is 'on vacation'.

The color of the value is always red - it does not change color.

PHP Code:


			
<?php 
include("config.php"); 
$connection=mysql_connect($hostname,$user,$pass) or die ("Failed to connect."); 
mysql_select_db($dbname,$connection) or die ("Cannot connect to DB"); 
 
 
$result=mysql_query("SELECT * FROM rlgl_std WHERE id='$id'") or die ("Could not execute query."); 
 
$id=$_GET['id']; 
 
while($rows=mysql_fetch_array($result)){ 
?> 
<html> 
<head> 
</head> 
 
<body> 
<?php 
$availability=$_GET['availability']; 
if ( $availability='Red' ) { 
    echo "<p style=\"color:#ff0000\">$rows[availability]</p>"; 
} 
elseif ( $availability='Yellow' ) { 
    echo "<p style=\"color:#ffcc00\">$rows[availability]</p>"; 
} 
elseif ( $availability='Green' ) { 
    echo "<p style=\"color:#009900\">$rows[availability]</p>"; 
} 
elseif ( $availability='On Vacation' ) { 
    echo "<p style=\"color:#000066\">$rows[availability]</p>"; 
} 
} 
?> 
</body> 
</html>

**NullPointer** · 07-13-2010, 08:54 AM

You are using the assignment operator = instead of the comparison operator ==.

The behavior you described is occurring because, in PHP, assignments return the value being assigned. In an if statement, anything that isn't false, 0, the empty string, or null is considered false. Everything else is true, hence $availability='Red' evaluates to true.

**beylah** · 09:17 AM

when i use the == i get no result

i have tried this and get no results either

if ( $availability=='Red' ) {
echo '<p style="color:#ff0000;text-align:center;font-family:Helvetica,sans-serif;font-size:12px;font-weight:bold">'.$rows['availability'].'</p>';
}

**beylah** · 07-13-2010, 10:21 AM

i have resolved it - i instead of using

PHP Code:


			
$availability=$_GET['availability'];

i have used

PHP Code:


			
$availability=$rows['availability'];

PHP Code:


			
$availability=$rows['availability']; 
if ( $availability=="Red" ) 
{ echo "<p style=\"color:#ff0000\">Red</p>"; } 
if ( $availability=="Yellow" ) 
{ echo "<p style=\"color:#ffcc00\">Yellow</p>"; } 
if ( $availability=="Green" ) 
{ echo "<p style=\"color:#009900\">Green</p>"; } 
if ( $availability=='On Vacation' ) 
{ echo "<p style=\"color:#000066\">On Vacation</p>"; }