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>"; } } ?> Link to comment https://forums.phpfreaks.com/topic/241122-im-having-trouble-with-alternating-row-colors/ 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++; } Link to comment https://forums.phpfreaks.com/topic/241122-im-having-trouble-with-alternating-row-colors/#findComment-1238488 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. Link to comment https://forums.phpfreaks.com/topic/241122-im-having-trouble-with-alternating-row-colors/#findComment-1238498 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.