the Line <?php echo $row_Recordset1['resolved']; ?> in my PHP ['resolved'] is the Actual Table Name so what thats Doing is Displaying the Value in the table resolved whether its Pending resolved or Open the values come from a drop down box when inputing the Issue
can't we Do this ?? if($row_Recordset1['pending']=(open})){echo "<td bgcolor=\"other color\"><font color=\"other color\" size=\"2\">"; if($row_Recordset1['pending']=(resolved})){echo "<td bgcolor=\"other color\"><font color=\"other color\" size=\"2\">"; so what u have if($row_Recordset1['pending']){ echo "<td bgcolor=\"other color\"><font color=\"other color\" size=\"2\">"; echo $row_Recordset1['pending']; echo "</font></td>"; } elseif($row_Recordset1['reslved']){ there is no pending table so it throws Errors William Piper wrote: > > > > Brian E Boothe wrote: > > > > > > i would like the Rows for my Column "Status" to change colors depending > > on whether its PENDING / RESOLVED /OPEN / > > my Code for that now is > > <td bgcolor="#00FF33"><font color="#003399" size="2"><?php echo > > $row_Recordset1['resolved']; ?></font></td> > > in which is all green , can anyone Help me out > > thanks > > > Try this: > <? > if($row_Recordset1['pending']){ > echo "<td bgcolor=\"other color\"><font color=\"other color\" > size=\"2\">"; > echo $row_Recordset1['pending']; > echo "</font></td>"; > } > elseif($row_Recordset1['reslved']){ > echo "<td bgcolor=\"#00FF33\"><font color=\"#003399\" size=\"2\">"; > echo $row_Recordset1['resolved']; > echo "</font></td>"; > } > elseif($row_Recordset1['open']){ > echo "<td bgcolor=\"other color\"><font color=\"other color\" > size=\"2\">"; > echo $row_Recordset1['open']; > echo "</font></td>"; > } > ?> > William Piper > > [Non-text portions of this message have been removed]