[Resolved] while loop

neo100101

I have a script that 'cycles' through my database and retrieves records based on user login data. Some of the records are marked 'inactive' but display anyway. I want these records to display but a different color 'inactive = red' the rest = black but can't seem to figure out a way to do so.

I have a statement in there right now that says
$font = ($a_row[activity] == 0) ? 'Red' : 'Black';

but that changes the whole table Red not just the records with activity '0'.

is there any other way to do this? I'm open to suggestions 🙂

pipe_girl

Try moving the font statement into the while loop.

<?
$counter = 0;
while ($a_row = mysql_fetch_assoc($result))
{

//CHANGE FONT TO RED IF ACCOUNT IS INACTIVE................
$font = ($a_row[activity] == 0) ? 'Red' : 'Black';
//CONTINUE WITH SCRIPT.....................................................

$color = (($counter % 2) == 1) ? '#EEEEEE' : '#FFFFFF';
   //print html
?>
<tr bgcolor = "<? echo $color; ?>">
    <td width="7%" style="padding-left: 5; padding-right: 5"><input type="hidden" value="<? $a_row[activity]; ?>"><font color="<? echo $font; ?>"><? echo $a_row[Ph_ID]; ?></td>
    <td width="19%" style="padding-left: 5; padding-right: 5"><font color="<? echo $font; ?>"><? echo $a_row[Pharmacy_Name]; ?></td>
    <td width="43%" style="padding-left: 5; padding-right: 5"><font color="<? echo $font; ?>"><? echo $a_row[Address_Line_1]; ?>&nbsp;|&nbsp;<? echo $a_row[City]; ?>,&nbsp;<? echo $a_row[Province]; ?>&nbsp;|&nbsp;<? echo $a_row[Postal_Code]; ?></td>
    <td width="15%" style="padding-left: 5; padding-right: 5"><font color="<? echo $font; ?>"><? echo $a_row[Phone]; ?></td>
    <td width="5%" style="padding-left: 5; padding-right: 5"><a href="details.php?Ph_ID=<? echo $a_row[Ph_ID]; ?>">Details</a></td>
    <td width="11%" style="padding-left: 5; padding-right: 5"><p align="center"><input type=checkbox name="hotlist[]" value="<? echo $a_row[Ph_ID]; ?>"></td>
  </tr>
<?
$counter++;
   }
?>

Let me know if that works.
Jamie 🙂

neo100101

yep... worked like a charm, thanks for your help 🙂