display in tables

[nuttynibbles]

im displaying items in a table. is like a football league table. here is my code:

<tr bgcolor="#E8E8E8">
<td><?php
 $index=1;
include ("dbmsConn.inc");
$strSql =  mysql_query('SELECT * FROM football ORDER BY Count DESC'); //orderby descending 

while($row = mysql_fetch_array($strSql, MYSQL_ASSOC))
{					 
	echo $index;					 
?>
</td>
<td align="center">
<?php						

$website = $row['URL'];
$score= $row['Score'];
$team= $row['Team'];
$url_id=$row['ID'];		

/*print out data */
echo "<A href='loadurl.php?id=$url_id'><img src='Upload/$image' height=25 width=25 border=0></A> ";
echo"</td></tr><tr><td>";

?>
</td>

so how do i change every alternate row to a choosen color?

[devinemke]

alternating between white and grey...

include('dbmsConn.inc');
$result = mysql_query('SELECT * FROM football ORDER BY Count DESC') or exit(mysql_error()); 
$i = 1;
echo '<table border="1">';
while ($row = mysql_fetch_assoc($result))
{
	if ($i & 1) {$bgcolor = 'white';} else {$bgcolor = 'grey';}

echo '
<tr bgcolor="' . $bgcolor . '">
<td>' . $i . '</td>
<td><a href="loadurl.php?id=' . $row['ID'] . '"><img src="Upload/' . $image . '" height="25" width="25" border="0"></a></td>
</tr>
';  
}
echo '</table>';

[Bobulous]

I'd never thought of doing it that way before, divinemke. I've always used the modulo operator. I'm guessing your way is actually more efficient?

[devinemke]

Bobulous wrote:

I'm guessing your way is actually more efficient?

i've never bothered to benchmark it, but i would assume that using the bitwise operator would require less overhead than the modulo operator, though in a situation like this i think the difference would be neglible.

[nuttynibbles]

hi devinemke, I will show u my entire code which display the league table:

 
<?php
	echo "<table width='536' height='48' border='0' align='center' cellpadding='3' cellspacing='0' >";
	echo "<tr bgcolor='#3399CC'>";
	echo "<td width='28' height='21' align='center'>
	<span class='style7'>No
	</span>
	</td>";

    echo "<td width='43'><div align='center'><span class='style7'>Logo
</span></div> </td>";
echo "<td width='402'><div align='center'><span class='style7'>Description
</span></div> </td>";
echo "<td width='29'><div align='center'><span class='style7'>HIT
</span></div></td></tr>";
echo "<tr>";
echo "<td>";       	 
$index=1;
 include ("dbmsConn.inc");
$strSql =  mysql_query('SELECT * FROM customer ORDER BY Count DESC'); //orderby descending 

 while($row = mysql_fetch_array($strSql, MYSQL_ASSOC))
{	
	echo $index;	
	$website = $row['URL'];
	$desc=$row['Description'];
	$click = $row['Count'];
	$image = $row['Image'];
	$url_id=$row['ID'];

	echo "<td align='center'>";		
	/*print out data */
	echo "<A href='loadurl.php?id=$url_id'><img src='Upload/$image' height=25 width=25 border=0></A> ";
            echo "</td>";
	echo "<td>";
	if($desc=="")
		$desc="There is nothing I wanna say!!";

	echo"<strong>$desc</strong>";
	echo "</td>";

	echo "<td align='center'>";

	if($click=="")
		$click=0;
	echo "<strong>$click</strong>";				  
	echo"</td></tr><tr><td>";//to add the next data into the next row

	$index++;
    }//end of while loop	
echo "</td></tr></table>";				 
?>	

I've seen ur code but i do now relli understand how to integrate into my code.
In ur code, u actually created a new table in ur php script. How do i modify my code to display the alter color in each table row.. thanks

[nuttynibbles]

Hey devinemke, i've solved it. thanks alot dude!!

[Bobulous]

I actually recommend using CSS classes instead of fixed colours.

Instead of bgcolor="white" and bgcolor="grey", use class="even" and class="odd".

That way you can change the appearance using a single stylesheet, rather than modifying your PHP code every time you want to try a new look.

(CSS 3 introduces selectors that allow modulo operations, but I don't think any browsers support CSS 3 yet. Which is a shame.)