[SOLVED] Double Output

[tj71587]

Hey everyone, this is a piece of the php code I'm making.  I want every other row to come out a different color, but the problem is since I've implemented this code, I have been receiving double output.  I think I pretty much understand why that is happening, but how is the fix?

 

Thanks

 

$query .= " ORDER BY h.ticketno DESC";
$result = mysql_query($query);
$countvar = 0;

while($r=mysql_fetch_array($result))
{	
   //the format is $variable = $r["nameofmysqlcolumn"];
   //modify these to match your mysql table columns
   
   $ticketno=$r["ticketno"];
   $connect=$r["connect"];
   $date=$r["date"];
   $rmnum=$r["rmnum"];
   $problem=$r["problem"];
   $resolution=$r["resolution"];
   $connected=$r["connected"];
   

 if ($countvar % 2 <> 0)
   {
   //display the row
     echo "<tr>";
 echo "<td class = \"everyother\">";
 echo $ticketno;
 echo "</td>";
 echo "<td class = \"everyother\">";
 echo $connect;
 echo "</td>";
 echo "<td class = \"everyother\">";
 echo $date;
 echo "</td>";
 echo "<td class = \"everyother\">";
 echo $rmnum;
 echo "</td>";
 echo "<td class = \"everyother\">";
 echo $problem;
 echo "</td>";
 echo "<td class = \"everyother\">";
 echo $resolution;
 echo "</td>";
 echo "<td class = \"everyother\">";
 echo $connected;
 echo "</td>";
 echo "</tr>";

 $countvar = $countvar + 1;
 }

 if ($countvar % 2 == 0)
   {
   //display the row
     echo "<tr>";
 echo "<td>";
 echo $ticketno;
 echo "</td>";
 echo "<td>";
 echo $connect;
 echo "</td>";
 echo "<td>";
 echo $date;
 echo "</td>";
 echo "<td>";
 echo $rmnum;
 echo "</td>";
 echo "<td>";
 echo $problem;
 echo "</td>";
 echo "<td>";
 echo $resolution;
 echo "</td>";
 echo "<td>";
 echo $connected;
 echo "</td>";
 echo "</tr>";
 $countvar = $countvar + 1;
 }
}

 

I have since figured the error out, I needed an else if and not an if for the second condition.

[kratsg]

That's a lotta unneeded code. Try this.

 

$query .= " ORDER BY h.ticketno DESC";
$result = mysql_query($query);
$countvar = 0;

$rowcounter = 2;

while($r=mysql_fetch_array($result))
{	
   //the format is $variable = $r["nameofmysqlcolumn"];
   //modify these to match your mysql table columns
   
   $ticketno=$r["ticketno"];
   $connect=$r["connect"];
   $date=$r["date"];
   $rmnum=$r["rmnum"];
   $problem=$r["problem"];
   $resolution=$r["resolution"];
   $connected=$r["connected"];
   if($rowcounter % 2){$class = " class = \"everyother\"";} else {$class = null;}


   {
   //display the row
     echo "<tr>";
 echo "<td$class>";
 echo $ticketno;
 echo "</td>";
 echo "<td$class>";
 echo $connect;
 echo "</td>";
 echo "<td$class>";
 echo $date;
 echo "</td>";
 echo "<td$class>";
 echo $rmnum;
 echo "</td>";
 echo "<td$class>";
 echo $problem;
 echo "</td>";
 echo "<td$class>";
 echo $resolution;
 echo "</td>";
 echo "<td$class>";
 echo $connected;
 echo "</td>";
 echo "</tr>";

 $rowcounter++;
 }
}