Switching table cell colors

[closer2u]

Hello,
I have my code working and it displays 10 results per page and has pagination.

Now, what I would like is to have the table cells switching in color.

table cell 1: white
table cell 2: grey
table cell 3: white
and so on...

If anyone could help me out or can point me to a topic that has handled this subject before (could't find one myself) it would be greatly appreciated!

Current code:

<? 
$HTTP_GET_VARS["cat"]; 
if ($cat == "") ($section = "12"); 
else $section = $cat; 

$DBHost = "****";$DBUser = "****";$DBPass = "****";$DBName = "****"; 
$DBConn = mysql_connect($DBHost,$DBUser,$DBPass) or die("Unable to connect to database"); 
$DBSele = mysql_select_db("$DBName") or die("Unable to select database $DBName"); 
$DBQuery = "SELECT id FROM ringtones WHERE sectionid = $section"; 

/* Set current, prev and next page */ 
$page = (!isset($_GET['page']))? 1 : $_GET['page']; 
$prev = ($page - 1); 
$next = ($page + 1); 

/* Max results per page */ 
$max_results = 10; 

/* Calculate the offset */ 
$from = (($page * $max_results) - $max_results); 

/* Query the db for total results. You need to edit the sql to fit your needs */ 
$result = mysql_query("$DBQuery") or die (mysql_error()); 

$total_results = mysql_num_rows($result); 

$total_pages = ceil($total_results / $max_results); 

$pagination = ''; 

/* Create a PREV link if there is one */ 
if($page > 1) 
{ 
$pagination .= '<a href="index.php?page='.$prev.'">Previous</a> '; 
} 

/* Loop through the total pages */ 
$HTTP_GET_VARS["cat"]; 
if ($cat == "") ($cat = "12"); 
for($i = 1; $i <= $total_pages; $i++) 
{ 
if(($page) == $i) 
{ 
$pagination .= '<b>'.$i.'</b>'; 
} 
else 
{ 
$pagination .= ' <a href="header.php?page='.$i.'&cat='.$cat.'">'.$i.'</a>'; 
} 
} 

/* Print NEXT link if there is one */ 
if($page < $total_pages) 
{ 
$pagination .= ' <a href="header.php?page='.$next.'&cat='.$cat.'">Next</a>'; 
} 

echo '<table width="100%">'; 
$result=mysql_query("SELECT * FROM ringtones WHERE sectionid = $section LIMIT $from, $max_results "); 

while ($i = mysql_fetch_array($result)) 
{ 
/* This is where you print your current results to the page */ 

echo '<tr><td bgcolor="#FFFFFF">'. $i["ringtoneid"] . ' - ' . $i["artist"] . ' - ' . $i["song"] . '</td></tr>'; 
} 
echo '</table><br />'; 
echo $pagination; 
?> 

[revdev]

Try here: http://www.sitepoint.com/article/background-colors-javascript.

I've never done it, but I'm sure you'll need javascript, not PHP.

If that one doesn't work, http://www.google.com/search?q=javascript+table+cell+alternating+color

[Weedpacket]

It can be done in PHP; there's a thread on the subject linked to in this forum's FAQ.

[Nugen]

Very simple example incoming - put this type example in your While statement when looping through your results:

$START_ROW=1;

switch($START_ROW) {
 case 1:
     $MY_ROW_COLOR="row_color_1";
     $START_ROW++:
     break;
 case 2:
     $MY_ROW_COLOR="row_color_2";
      $START_ROW++:
     break;
 case 2:
     $MY_ROW_COLOR="row_color_3";
     $START_ROW=1;
     break;

}  

[tony_l]

UH... No you do not need Javascript

I do it this way -

$rowcolor = "#ffffff";

While ([condition])
{

//use the ternary operator here if you want - but for readability I wil use IF 
IF($rowcolor == '#ffffff')
$rowcolor = '#000000';
ELSE
$rowcolor = '#ffffff';

PRINT"<tr bgcolor = '$rowcolor'>";

...blah blah more code here

}

[barkerja]

<table>
<?php

$x = 1; // 0 = starts with gray, 1 starts with white

while (condition) {
	if (($x % 2) == 0) {
		echo '<tr bgcolor="gray"><td>...</td></tr>';
	}
	else {
		echo '<tr bgcolor="white"><td>...</td></tr>';
	}

$x++;
}

?>
</table>

[Catharsis]

Use Smarty Template iss my opinion, does a lot of this kinda stuff for you.

http://smarty.php.net/