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++; }