vet911 Posted July 5, 2011 Share Posted July 5, 2011 I'm having trouble with alternating row colors. My code works as far as alternating row colors, my real problem is that it gives me 4 of each row before it changes to the next row. I think my problem is in this (for($i = 0; $i < $numrows; $i++) {) but not sure how to fix it. Any help would be greatly appreciated. Thanks in advance. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title></title> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> <link rel="stylesheet" href="css.css" media="all"/> <? // Connects to your Database include("connect.php"); $getnews = mysql_query("select * from news ORDER BY id DESC") or die (mysql_error()); $numrows = mysql_num_rows($getnews); while($r=mysql_fetch_array($getnews)){ //get a row from our result set for($i = 0; $i < $numrows; $i++) { extract($r); echo "$i"; echo "<div class='ns' style='width: 569px';>"; if($i % 2) { //this means if there is a remainder echo "<div class='darkcell'>"; } else { echo "<div class='lightcell'>"; } echo "<div id='pad'>$date<br><a><strong>$title</strong></a><br>$news"; echo "</div>"; echo "</div>"; } } ?> Quote Link to comment Share on other sites More sharing options...
TeNDoLLA Posted July 5, 2011 Share Posted July 5, 2011 Try this <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title></title> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> <link rel="stylesheet" href="css.css" media="all"/> <? // Connects to your Database include("connect.php"); $getnews = mysql_query("select * from news ORDER BY id DESC") or die (mysql_error()); $numrows = mysql_num_rows($getnews); $i = 0; while($r=mysql_fetch_array($getnews)){ //get a row from our result set extract($r); echo "$i"; echo "<div class='ns' style='width: 569px';>"; if($i % 2) { //this means if there is a remainder echo "<div class='darkcell'>"; } else { echo "<div class='lightcell'>"; } echo "<div id='pad'>$date<br><a><strong>$title</strong></a><br>$news"; echo "</div>"; echo "</div>"; $i++; } Quote Link to comment Share on other sites More sharing options...
vet911 Posted July 5, 2011 Author Share Posted July 5, 2011 Worked like a charm, Thanks, I really appreciate the help. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.