[Resolved] Changing $color value if condition is met

[chrima]

Hi all,
If i have the following code:

<table class=footer width="80%" border="0" cellpadding="0" cellspacing="5">
<?
$sql = "SELECT * FROM orders WHERE customer_id = '" . $_GET['id'] . "' ORDER BY order_date DESC";
$result = mysql_query($sql);

$alternate = "2";

while($row = mysql_fetch_array($result)){
$order_id = $row["order_id"];
$movie_title = $row["movie_title"];
$movie_current_price = $row["movie_current_price"];
$qty = $row["qty"];
$order_date = $row["order_date"]; 
$processed = $row["processed"];


if ($alternate == "1") { 

$color = "#ffffff"; 

$alternate = "2"; 

} 

else { 

$color = "#efefef"; 

$alternate = "1"; 
}
?>	
   <tr class="smallText" bgcolor="<? echo $color ?>">
      <td height="20">&nbsp;&nbsp;<? echo $order_date ?></td>
      <td>&nbsp;&nbsp;<? echo $order_id ?></td>
      <td>&nbsp;&nbsp;<? echo $movie_title ?></td>
      <td>&nbsp;&nbsp;<? echo $movie_current_price ?></td>
      <td>&nbsp;&nbsp;<? echo $qty ?></td>
	  <td>&nbsp;
	  <? 
	  if ($processed == 'N'){ 
	  echo "NO";
	  } else if ($processed == 'Y'){
	  echo "YES";
	  }
	  ?>
	  </td>
  </tr>
<?
}
?>
</table>
<?
}
?>

and in the mySQL table called orders i have, lets say, 5 entries. If two of those
entries have the same customer_id and order_date how do i get them to display the same
$color background value and then continue on through the loop process?

Cheers,
chrima

[bad76]

Hi,
i see that the customer_id is always the same (WHERE customer_id = '" . $_GET['id'] tell this...). Then just look for the date.

You memorize at each loop the old date and compare with new before to change the color:

if ($olddate!=$order_date){
  if ($alternate == "1") {  

    $color = "#ffffff";  

    $alternate = "2";  

  } else {  

    $color = "#efefef";  

    $alternate = "1";  

  } 
  $olddate=$order_date;
}

If the customer change too you can use the same trick, but you have to order also for customer_id, so near customer may be the same, the far not.

see you

[chrima]

Thanks bad76, that worked great 🙂
I thought the process would be alot more involved than that.

Cheers,
chrima