Hi Monks!
I have this part of my code here to demonstrated what I am trying to do, which is alternating the colors of the rows based on the query results. I know there are many ways of doing this using odd and even numbers, but because of the nature of this particular query results the values of the counter "$i" will not be in order or sequence, this block of code will print the values of $i as:
0 2 14 15 16 19 20
I am thinking that the only way is to compare the values of $i and if they are different assign a value I could use to do the color alternation, but I am running out of ideas, any help would be very appreciated, thanks for the help!
for (my $i = 0; $i < @$sql; $i++)
 {
   my $user = $sql->[$i]{user};
                
   if($unique{$user})
    {
      next;
    }
   $unique{$user} = 1;
                
   my $show = "<a href=\"show.pl?name=$name\">$name</a>";
   my $first = $sql->[$i]{first};
   my $last = $sql->[$i]{last};
   my $tel = $sql->[$i]{tel};
   my $email = $sql->[$i]{email};
                                                                      
+ 
  if ($i % 2)
   {
     $data = "$data<tr><td>$last, $first</td>
                       <td>$show</td>
                       <td>$email</td>
                       </tr>";
   }else {
     
           $data = "$data<tr><td>$last, $first</td>
                             <td>$show_link</td>
                             <td>$email</td>
                         </tr>";
   }

}

[download]

In reply to Alternating Table Row Colors Help! by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.