alternating rows...i think i'm close...

vaska

i can't get the color variable to work...although the script is working...just not the variable...any help?

the code...

<? $query = mysql_query ("SELECT * from main WHERE status='Draft' ORDER by date LIMIT 0,20") or die ("Yo, it's not working! - Code1A.");

while ($row = mysql_fetch_array($query)) { $i=0; $color1= "#ffffff"; $color2= "#000000"; if($i % 2) { $color = $color1; $i++; } else { $color = $color2; $i++; } ?>
<tr bgcolor="<? echo $color; ?>">
      <td width="80" height="21" align="left" valign="top" class="unnamed3a">&nbsp;<? echo $row['udate']; ?></td>
      <td align="left" valign="top" class="unnamed3a"><a href="edit_entry.php?id=<? echo $row['id']; ?>" target="work"><? echo $row['title']; ?></a></td>
    </tr>
    <tr> 
      <td colspan="2" bgcolor="#FFFFFF"><img src="imgs/spcr.gif" width="10" height="1"></td>
    </tr>

<? } ?>

GSHelpBoy

<?php
$query = mysql_query ("SELECT * from main WHERE status='Draft' ORDER by date LIMIT 0,20") OR die ("Yo, it's not working! - Code1A.");

$i = 0;
while ($row = mysql_fetch_array($query)) {
    $color1 = "#ffffff";
    $color2 = "#000000";
    if (is_integer($i % 2)) {
        $color = $color1;
        $i++;
    } else {
        $color = $color2;
        $i++; 
    }
?>
    <tr bgcolor="<?php echo $color; ?>">
      <td width="80" height="21" align="left" valign="top" class="unnamed3a">&nbsp;<? echo $row['udate']; ?></td>
      <td align="left" valign="top" class="unnamed3a"><a href="edit_entry.php?id=<?php echo $row['id']; ?>" target="work"><?php echo $row['title']; ?></a></td>
    </tr>
    <tr> 
      <td colspan="2" bgcolor="#FFFFFF"><img src="imgs/spcr.gif" width="10" height="1"></td>
    </tr>

<?
}
?>

vaska

hmmm...the last time i would get all black rows...this time i'm only getting all white rows...let's compare the code...i believe it's identical to yours...but it's still not working...???

<? $query = mysql_query ("SELECT * from main WHERE status='Draft' ORDER by date LIMIT 0,20") or die ("Yo, it's not working! - Code1A.");
$i = 0;
while ($row = mysql_fetch_array($query)) {
$color1 = "#ffffff";
$color2 = "#000000";
if (is_integer($i % 2)) {
$color = $color1;
$i++;
} else {
$color = $color2;
$i++;
}
?>
<tr bgcolor="<? echo $color; ?>">
      <td width="80" height="21" align="left" valign="top" class="unnamed3a">&nbsp;<? echo $row['udate']; ?></td>
      <td align="left" valign="top" class="unnamed3a"><a href="edit_entry.php?id=<? echo $row['id']; ?>" target="work"><? echo $row['title']; ?></a></td>
    </tr>
    <tr> 
      <td colspan="2" bgcolor="#FFFFFF"><img src="imgs/spcr.gif" width="10" height="1"></td>
    </tr><? } ?>

diego25

The mod operator always returns an integer, so
if (is_integer($i % 2)) {
will always be true.

Try either:

if (is_integer($i / 2)) {

if ($i % 2 == 0) {

Diego

vaska

and that explained why i was only getting the one result...

did the trick...muchos gracias...jv