Alternating rows pulled from database
| From: | MrBaseball34 | Date: | Thu, 29 Nov 2001 15:31:26 +0000 |
| Subject: | Alternating rows pulled from database | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14691@lists.php.net to get a copy of this message | ||
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;
}