Changing my row colours

[jerrylouise]

Ok i what i have kinda works but not fully just yet. Currently it will print the top most TR the right colour but not the TR that is ment to be the same colour after it.
http://www.dev.cossycomforts.com/forum.php It is supposed to make the title and the text below the title the same colour to seperate it better.

<?php
$sql = "SELECT s.`id`, s.`catagory`, c.`title`, c.`about` FROM `forum-catagory` AS `s` LEFT JOIN `forum-topics` AS `c` ON s.`id` = c.`catagory_id` ORDER BY s.`id`";
$result = mysql_query($sql) or die("Query failed($sql): " . mysql_error()); 
   print '<table width="100%" border="0" cellpadding="3" cellspacing="0" >';
?>
<tr class="purple_top"><td width="70%"><font size="+2">Welcome to the forum <?php echo $usrname ?></font></td><td width="15%"></td><td width="15%"></td></tr>
<?php
print '<tr class="purple_top"><td width="80%">Forum</td><td width="10%">Topics</td><td width="10%">Posts</td></tr>'; 
$last_cat = ''; 
$i = 0; 
WHILE($row = mysql_fetch_array($result)) { 
    if($row['catagory'] != $last_cat) { 
        $last_cat = $row['catagory']; 
        printf("<tr class=\"purple_title\"><td>%s" . "</td><td></td><td></td></tr>", $row["catagory"]); 
    } 
    if($i++ % 2) 
      { 
         print '<tr class="pink">'; 
      } 
      else 
      { 
         print '<tr class="wight">'; 
      } 
	printf("<td>%s" . "</td><td>1</td><td>1</td></tr>", $row["title"]);
	printf("<tr><td><font size=\"-1\">%s" . "</font></td><td></td><td></td></tr>", $row["about"]); 
}
print '</table>'; 
?>

[sneakyimp]

looks like you need $i++ in your while loop?

[jerrylouise]

how would i do that?

[sneakyimp]

My mistake...it's in there where you check $i: if ($i++ %2).

having read your post again, i'm not sure what the problem is. your code doesn't refer to 'title' anywhere so i don't know what you mean.

[jerrylouise]

    if($i++ % 2) 
      { 
         print '<tr class="pink">'; 
      } 
      else 
      { 
         print '<tr class="wight">'; 
      } 
    printf("<td>%s" . "</td><td>1</td><td>1</td></tr>", $row["title"]); 
    printf("<tr><td><font size=\"-1\">%s" . "</font></td><td></td><td></td></tr>", $row["about"]);
}

Im refering to this bit it only changes the colour of the top printf and not the bottom.

    if($i++ % 2) 
      { 
         print '<tr class="pink">'; 
      } 
      else 
      { 
         print '<tr class="wight">'; 
      } 
    printf("<td>%s" . "</td><td>1</td><td>1</td></tr>", $row["title"]); 
 if($i++ % 2) 
      { 
         print '<tr class="pink">'; 
      } 
      else 
      { 
         print '<tr class="wight">'; 
      }
    printf("<td><font size=\"-1\">%s" . "</font></td><td></td><td></td></tr>", $row["about"]);
}

If i do it like above it only colors the bottom row and not both rows.

[sneakyimp]

if each printf statement corresponds to a row, then it's because the 2nd row is a distinct row (it has its own TR) tags which are in no way affected by the if statement.

[jerrylouise]

then why wont it let me use the bottom code with the two if's

[sneakyimp]

look closely at the 2nd printf statement...it already has a <tr> tag with no class definition:

    printf("<tr><td><font size=\"-1\">%s" . "</font></td><td></td><td></td></tr>", $row["about"]);

if you look at your html output, you'll probably see something like this coming from that 2nd if statement:

<tr class="pink"><tr><td><font size="-1">blah blah</font></td><td></td><td></td></tr>