Insert conditional if statement into <td> tag?

[bluetiger]

How do I insert this conditional statement:
if if ($err < "1" ) echo ('bgcolor="green"');
if ($err > "2" and $err < "5" or $err == "2" or $err == "5" ) echo ('bgcolor="yellow"');
if ($err > "6" or $err == "6" ) echo ('bgcolor="red"');

into the <td> tag of this array & not get this error:
Parse error: parse error, expecting ','' or';''

while ($r = mysql_fetch_array($result)) {

$name = $r["Name"];
$location = $r["Location"];
$err = $r["Error"];
$band = $r["Bandwidth"];
$cpu = $r["CPU"];
$conn = $r["Connectivity"];

echo "<tr>
<td align=center>$name</td>
<td align=center>$location</td>
<td align=center>$err</td>
<td align=center>$band</td>
<td align=center>$cpu</td>
<td align=center>$conn</td>
</tr>";
}

**
I tried this first and got the parse error:
<td align=center if ($err < "1" ) echo ('bgcolor="green"');
if ($err > "2" and $err < "5" or $err == "2" or $err == "5" ) echo ('bgcolor="yellow"');
if ($err > "6" or $err == "6" ) echo ('bgcolor="red"');>$err</td>

**
Any ideas?
Thx in advance for any & all help!

[bernouli]

try this

while ($r = mysql_fetch_array($result)) { 

$name = $r["Name"]; 
$location = $r["Location"]; 
$err = $r["Error"]; 
$band = $r["Bandwidth"]; 
$cpu = $r["CPU"]; 
$conn = $r["Connectivity"]; 
if ($err < "1" ) $bgcolor="green";
if ($err > "2" and $err < "5" or $err == "2" or $err == "5" ) $bgcolor="yellow"; 
if ($err > "6" or $err == "6" ) $bgcolor="red";

echo "<tr> 
<td align=center>$name</td> 
<td align=center>$location</td> 
<td align=center bgcolor=$bgcolor>$err</td> 
<td align=center>$band</td> 
<td align=center>$cpu</td> 
<td align=center>$conn</td> 
</tr>"; 
} 

[tomhath]

Still a couple of things wrong. You missed the condition when $err == 1, and since you are comparing strings (not numbers) things might not do what you expect if $err >= '10'.

if ($err <= 1 ) $bgcolor="green";
if ($err >= 2 and $err <= 5) $bgcolor="yellow"; 
if ($err >= 6 ) $bgcolor="red";