displaying query records in 4 columns

[chinto09]

Hi
i have been able to display 4 records per row in an html table. Next i want to change the background color of <tr> on each iteration.

what i have done so for is

 <table cellpadding="4" cellspacing="2" border="1" width="80%" align="center">
 <tr>
<?php

$query = "SELECT * FROM ....";
$result = mysql_query($query);
if(!$result) echo 'Problem in executing query ' . mysql_error();


$numcols = 4; // how many columns to display
$numcolsprinted = 0; // no of columns so far

while($myrow = mysql_fetch_assoc($result))
{
if ($numcolsprinted == $numcols)
	{
	print "</tr>\n<tr>";
	$numcolsprinted = 0;

}

?>
<td>
<?php
echo $myrow['m_id'];

// bump up row counter
$numcolsprinted++;
?>
</td>
<?php 
}?> 


</tr>
</table>
</html> 

thanks in advance 🙂

[djjjozsi]

creat CSS style,

<style type="text/css">
<!--
.gray {
	background-color: #CCCCCC;
}
-->
</style>

in the while cycle check the rowcounter:

$gray="gray";
$while="";
$style = ($numcolsprinted % 2) ? $gray : $white;

then print the TR tag like this:

print "<tr class=\"$style\">";

You're thinking of this?
Hello, jjozsi.