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

I don't know if this is a better way to do it, but here's how I do it: $return = mysql_query("SELECT This FROM That WHERE This = That"); Print "<table> For($i=1;$i<=count(mysql_num_rows($return);$i++) If($i % 2 == 0){$color="color1";} else {$color="color2";} Print " <tr bgcolor='#$color'> ". " <td>$value[$i]</td> ". " </tr> " ; } Print "</table> " ; Ryan -----Original Message----- From: Lee Willmann [mailto:lwillmann@mailcity.com] Sent: Friday, November 30, 2001 10:51 AM To: php-db@lists.php.net Subject: [PHP-DB] Re: Alternating rows pulled from database 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++; > } > >