Re: Alternating rows pulled from database

From: Date: Fri, 30 Nov 2001 15:51:28 +0000
Subject: Re: Alternating rows pulled from database
References: 1 2 3  Groups: php.db 
Request: Send a blank email to php-db+get-14716@lists.php.net to get a copy of this message
I guess it would since you're doing basically the same thing, just a different route. "Mrbaseball34" <mrbaseballthirtyfour@hotmaildot.com> wrote in message news:MPG.167057bc3b00ac6d98969d@216.92.131.4... > 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++; > } > >

« previous php.db (#14716) next »