[PHP-DB] Re: Alternating rows pulled from database From: MrBaseball34 (mrbaseballthirtyfour <email protected>)
Date: 11/29/01

In article <20011129202122.85089.qmail <email protected>>, lwillmann <email protected>
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 <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>