Alternating table row colors of MySQL Result Display? 2

[WilliamMute]

hi,

I am trying to display a mysql query recordset/result. When I display them in a table all the rows are the same color. I s there any way I can Alternate the row colours to different colours? this is of course for easier reading of each row of data.


Thank you for your help please.

 

[Vragabond]

Of course there is. Just introduce a variable that has two states and alter its state after every row is ouputted. Before you output row check for the state of this variable and define the color accordingly.

 

[WilliamMute]

thanks Vragabond for your response. I kind of understand what you are saying but at the same time not quite. so what you are saying is define a vriable and use a for loop for it or how can i introduce it in my while statement i.e

while ($row = mysql_fetch_assoc($recordset):

echo'whatever row';

endwhile;

how do i alternate the rows colour in this instance?

Cheers.

 

[Vragabond]

To continue with your example, something simple as:

$row = 1;

while ($row = mysql_fetch_assoc($recordset):

if ($row == 1)
{
  echo '<tr class="oddrow">';
}
else
{
  echo '<tr class="evenrow">';
}

echo 'table cells and end row';

$row = -$row;

endwhile;

 

[WilliamMute]

I see your example above but I think maybe because a quite new to PHP thats why its not quite hitting the spot pls bare with me. here is the reall code

<?php while ($row_Recordset1 = mysql_fetch_assoc($Recordset1) ) :?>

<tr class="LoopRowsQuery"><p>
<td width="173" align="center" class="LoopRowsQuery"><p><a href="#"><img src="<?php echo "../products/". $row_Recordset1['image']; ?>.jpg"></td>


<?php

endwhile;

?>


thank you for your hello

 

[jpadie]

<?php 
$class= "even_row";
?>
<style>
.even_row {background-color:#CCCC00;}
.odd_row {background-color:#00CCFF;}
</style>
<?
while ($row_Recordset1 = mysql_fetch_assoc($Recordset1) ) :
$class = ($class === "even_row") ? "odd_row" : "even_row";
?>

<tr class="<?=$class?>">
 <td width="173" align="center" ><a href="#"><img src="<?php echo "../products/". $row_Recordset1['image']; ?>.jpg"></a></td></tr>
     

<?php 
  
endwhile;

?>

 

[WilliamMute]

Thanks a million guys working perfect now couldnt be more thankful!


Cheers