RE: [PHP-DB] Re: Alternating rows pulled from database

Not knowing what else is going on here... at the very least your row counting variable is inconsistent. You mention row_count (in the modulus test) and rowcount (in the initialization and incrementation). > -----Original Message----- > From: MrBaseball34 [mailto:mrbaseballthirtyfour@hotmaildot.com] > Sent: Thursday, November 29, 2001 3:34 PM > To: php-db@lists.php.net > Subject: [PHP-DB] Re: Alternating rows pulled from database > > > In article <20011129202122.85089.qmail@pb1.pair.com>, > lwillmann@mailcity.com > says... > > Here's what I did to get alternating row colors on a > results page... I'm not > > sure that I follow what you are asking, but I hope this > will help you: > > > > > > $color_one = "dddddd"; > > $color_two = "cccccc"; > > $row_count = 0; > > // SEND QUERY > > while (row = fetch array(result)) > > { > > $row_color = ($row_count % 2) ? $color_one : $color_two; > > other fields from DB > > echo "<tr bgcolor=$row_color">; > > echo "<td>"; > > echo data out > > echo "</td>"; > > echo "</tr>"; > > $row_count++; > > } > > > > > > This is a really simple system. It uses the modulus (%) > operator. If the > > result of the math is even it uses color_one otherwise it > uses color_two.. > > > > I found it somewhere, can't remember where right now.. But > at least it works > > and it's only a few lines of code!! > > > <SNIP> > > Think this would work? > > $rowcount = 0 > while($forum = $db->fetch_array($query)) { > $forumlist .= ($row_count % 2) ? > forum($forum, "index_forum") : > forum($forum, "index_forum2"); > $rowcount++; > } > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net >