$query = "SELECT * FROM table";
$result = mysql_query($query);
$i = 1;
while($row = mysql_fetch_array($result)){
	if ($i % 2) {echo"<div style='background:#eaeaea;'>".$row['content']."</div>";}
	else {echo $row['content'];}
	$i++;
}

http://davidsword.ca/

highlight even/odd list from database

PHP