Need help changing color of font.

[Mark_Nordstrom]

Ok this is simple prob but i cant seem to figure it out. I have a table with names and salarys for each year. I queue the table using

name,year_one,year_two,year_three all the way to ten.

Now I wanna change the color of a persons year_one salary IF there year_two salary =0

I cant seem to figure this out. Everytime I try it makes that hole row red instead of the one persons who salary for year _two is 0. Any ideas ?

[devinemke]

while ($row = mysql_fetch_assoc($result))
{
	if ($row['year_two'] == 0) {$color = 'red';}
	else {$color = 'black';}

echo '
<tr>
<td>' . $row['name'] . '</td>
<td><font color="' . $color . '">' . $row['year_one'] . '</font></td>
<td>' . $row['year_two'] . '</td>
<td>' . $row['year_three'] . '</td>
</tr>
';
}

[Mark_Nordstrom]

I need to add that to this table

Thanks for help man, It works great. If your not busy thou I need help with it real quick.

<table border="1" cellpadding="0" cellspacing="0" bordercolor="#111111" width="100%" style="border-collapse: collapse; border-width: 0">
<tr valign="top" class="ar11">
<td nowrap width="40" bgcolor="#C0C0C0" align="center" style="border-style: none; border-width: medium">
<div align="center"><b>Team</b></div></td>
<td nowrap width="85" bgcolor="#C0C0C0" align="center" style="border-style: none; border-width: medium"><div align="center"><strong>NAME</strong></div></td>
<td nowrap width="40" bgcolor="#C0C0C0" align="center" style="border-style: none; border-width: medium">
<div align="center"><b>Year 1</b></div></td>
<td nowrap width="40" bgcolor="#C0C0C0" align="center" style="border-style: none; border-width: medium">
<div align="center"><b>Year 2</b></div></td>
<td nowrap width="40" bgcolor="#C0C0C0" align="center" style="border-style: none; border-width: medium">
<div align="center"><b>Year 3</b></div></td>
<td nowrap width="40" bgcolor="#C0C0C0" align="center" style="border-style: none; border-width: medium">
<div align="center"><strong>Year 4</strong></div></td>
<td nowrap width="40" bgcolor="#C0C0C0" align="center" style="border-style: none; border-width: medium"><div align="center"><strong>Year 5</strong></div></td>
<td nowrap width="40" bgcolor="#C0C0C0" align="center" style="border-style: none; border-width: medium">
<div align="center"><b>Year 6</b></div></td>
<td nowrap width="40" bgcolor="#C0C0C0" align="center" style="border-style: none; border-width: medium">
<div align="center"><b>Year 7</b></div></td>
</tr>
<?php do { ?>
<tr valign="top" class="ar11">
<td nowrap width="50" align="center" style="border-style: none; border-width: medium"><div align="center" class="ar11">
<div align="center"><?php echo $row_rat['team']; ?></div>
</div></td>
<td nowrap width="80" align="center" style="border-style: none; border-width: medium"><div align="left"><span class="style12"><a href="<?PHP echo "player.php?name=" . $row_rat['name'] .""; ?>"><?php echo $row_rat['name']; ?></a></span></div></td>
<td nowrap width="30" align="center" style="border-style: none; border-width: medium"><div align="center" class="ar11">
<div align="center" class="<?php if ($year_two = 0) { echo "ar11"; } else { echo "style21";} ?>"><?php echo number_format($row_rat['year_one']); ?></div>
</div></td>
<td nowrap width="30" align="center" style="border-style: none; border-width: medium"><div align="center" class="ar11">
<div align="center"><?php echo number_format($row_rat['year_two']); ?></div>
</div></td>
<td nowrap width="30" align="center" style="border-style: none; border-width: medium"><div align="center" class="ar11">
<div align="center"><?php echo number_format($row_rat['year_three']); ?></div>
</div></td>
<td nowrap width="30" align="center" style="border-style: none; border-width: medium"><div align="center" class="ar11">
<div align="center"><?php echo number_format($row_rat['year_four']); ?></div>
</div></td>
<td nowrap width="30" align="center" style="border-style: none; border-width: medium"><div align="center" class="ar11">
<div align="center"><?php echo number_format($row_rat['year_five']); ?></div>
</div></td>
<td nowrap width="30" align="center" style="border-style: none; border-width: medium"><div align="center" class="ar11">
<div align="center"><?php echo number_format($row_rat['year_six']); ?></div>
</div></td>
<td nowrap width="30" align="center" style="border-style: none; border-width: medium"><div align="center" class="ar11">
<div align="center"><?php echo number_format($row_rat['year_seven']); ?></div>
</div></td>
</tr>
<?php } while ($row_rat = mysql_fetch_assoc($rat)); ?>

Thats my table and I need to input that into it. I want it to read red thou say IF year 2 =0 then year_one is red for that person is red. But if year_three=0 for another person i want year 2 to read red for that person. If its confusing let me know. It goes all the way to year seven.

[Mark_Nordstrom]

anyone got any ideas ? Ive been up all night trying to get it to work.