[SOLVED] alternate row colour depending on variable?

[ale1981]

I can not figure this out, what I want to do is alternate the row colour of a table depending on a variable when looping through results from a db query, example;

 

ORD123

ORD123

ORD124

 

and so on..

 

<table>
$trclass = 'alt1'
$trclass = 'alt2'
while ($ord_inf = mssql_fetch_array($result)) {
  if ($ordinf['ORDERNO'] == $orderNo) {
    'keep same tr class as its the same order'
  } else {
    'its a different order so change the tr class'
  }
    <tr class="$trclass">
      <td>$ord_inf['ORDERNO']</td>
    </tr>
  $orderNo = $ord_inf['ORDERNO'];
}
</table>

 

something like that, i just cant seem to get it to work!

 

any help appreciated...

 

[/]

[sasa]

try

<table>
<?php
$trclass_array = array('alt1', 'alt2');
$orderNo = '';
$color = 1;
while ($ord_inf = mssql_fetch_array($result)) {
  if ($ordinf['ORDERNO'] != $orderNo) {
  	$color = 1 - $color;
  	$orderNo = $ordinf['ORDERNO'];
  }
  $trclass = $trclass_array[$color];
  //... etc
}
?>
</table>

[ale1981]

Hi, thanks for your reply but all rows end up the same colour, using alt1.

[ale1981]

SOLUTION for anybody interested;

 

<table>
<?php
while ($ord_inf = mssql_fetch_array($result))
{
        if($lastOrderNo != $ord_inf['ORDERNO'] || $lastOrderNo == "")
        {
                $trclass = ($trclass == 'alt2') ? 'alt1' : 'alt2';
        }
        $lastOrderNo = $ord_inf['ORDERNO'];
        ?>
        <tr class="<?php echo $trclass; ?>">
          <td><?php echo $ord_inf['ORDERNO']; ?></td>
        </tr>
        <?php
}
?>
</table>

[o3d]

Just my 2c using the modulus operator

 

for ($i=0; $i<10; $i++) {
	if (($i % 2) == 0) {
		//even colors
	}
	else {
		//odd colors
	}
}