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

I am trying to modify the XMB Forums to be more like
UBB in looks.

In this code, I want to alternate forum_index templates.

I have created two templates, one using $altbg1 and one using $altbg2. I want
to alternate the row colors...

How would I accomplish that?
{from: index.php}

code:
while($group = $db->fetch_array($queryg)) {
  if($group[type] == "group") {
    eval("\$forumlist .= \"".template("index_category")."\";");
    if($catsonly != "on" || $gid) {
      $query = $db->query("SELECT * FROM $table_forums WHERE type='forum'
                           AND status='on' AND fup='$group[fid]' ORDER BY
                           displayorder");
      while($forum = $db->fetch_array($query)) {
        $forumlist .= forum($forum, "index_forum");
      }
    }
  }else {
    $forumlist .= forum($group, "index_forum");
  }
}

What I really need to do is something like this:

      $i = 0
      while($forum = $db->fetch_array($query)) {
        if ($i % 2 = 0 {
          $forumlist .= forum($forum, "index_forum");
        } else {
          $forumlist .= forum($forum, "index_forum2");
        }
        $i = $i + 1;
      } 

-- 
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>