font color

nikko50

Hi there. I would like to test a variable called $onhand. If that variable is <=0 then I would like the font of that variable to be red. Here is my code. How would i code the statement??

while ($row= mysql_fetch_array($equipresult))
{ extract($row);
$onhand=$receivedsum-$shippedsum;
print "<table border=1 width=70% cellpadding=1 cellspacing=1 align=center>";
print "<tr>
<td width=35%>$item</td>
<td width=8%>$shippedsum</td>
<td width=8%>$receivedsum</td>
<td width=8%>$onhand</td>

</tr>

lilleman

Try this:

while ($row= mysql_fetch_array($equipresult))
{ extract($row);
$onhand=$receivedsum-$shippedsum;
$onhand = ( $onhand <= 0 ) ? '<span style="color: red">'.$onhand.'</span>' : $onhand;

print "<table border=1 width=70% cellpadding=1 cellspacing=1 align=center>";
print "<tr>
<td width=35%><font size='2'>$item</font></td>
<td width=8%><font size='2'>$shippedsum</font></td>
<td width=8%><font size='2'>$receivedsum</font></td>
<td width=8%><font size='2'>$onhand</font></td>
</tr>

-- lilleman

laserlight

Just do a test for it, of course:

while ($row = mysql_fetch_array($equipresult))
{
	extract($row);
	$onhand = $receivedsum - $shippedsum;
	echo "<table border=1 width=70% cellpadding=1 cellspacing=1 align=center>";
	echo "<tr>
<td width=35%><font size='2'>$item</font></td>
<td width=8%><font size='2'>$shippedsum</font></td>
<td width=8%><font size='2'>$receivedsum</font></td>
<td width=8%><font size='2'";
if ($onhand <= 0)
	echo " color='red'";
echo ">$onhand</font></td>
</tr>";

btw, you might want to consider using CSS instead of the deprecated tag.

nikko50

works great guys. Thanks so much
sharon🙂