printing records with alternating colours

[mankool]

I would like to print out candidate records in two colour where the bgcolour of a row changes when the ID of a candidate changes. The following is what I have written so far ...

 $studPrevious = '';
 $studCurrent = '';
                     
                 //Display the results
                 while($row = mysql_fetch_array($filterQueryResult, MYSQL_ASSOC))
                 {
                     $studCurrent = $row['studentID'];
                     if($studCurrent == $studPrevious)
                     {
                         echo '<tr bgcolor="#CCCCCC" align="center" valign="middle">
                                    <th scope="col">'.$row['studentID'].'</th>
                                    <td>'.$row['firstName'].'</td>
                                    <td>'.$row['secondName'].'</td>
                                 <td>'.$row['examDate'].'</td>
                                 <td>'.$row['moduleNumber'].'</td>
                                 <td>Yes</td>
                              </tr>';
                     }
                     else
                     {
                               echo '<tr bgcolor="#FFCCCC" align="center" valign="middle">
                                    <th scope="col">'.$row['studentID'].'</th>
                                    <td>'.$row['firstName'].'</td>
                                    <td>'.$row['secondName'].'</td>
                                 <td>'.$row['examDate'].'</td>
                                 <td>'.$row['moduleNumber'].'</td>
                                 <td>Yes</td>
                              </tr>';
                     }            
                     $studPrevious = $row['studentID'];
                 }//whie loop 

[mark_W]

Im not sure if this is what you are after or not but try this article!

http://www.zend.com/codex.php?id=399&single=1

[JZA]

Well you will use a class as far as I now which will be coded from the loop you generate on your table so that every other row would be = to class A which has the atribute of bakground-color: #<color>

[guido2004]

Try to duplicate as little code as possible. That way, if you want to change the layout of the table, or it's content, you only have to change it once.

     $studPrevious = '';
     $studCurrent = '';
                    
//Display the results
     while($row = mysql_fetch_array($filterQueryResult, MYSQL_ASSOC))
     {
         $studCurrent = $row['studentID'];
         if($studCurrent == $studPrevious)
         {
              $bgcolor = "#CCCCCC";
         }
         else
         {
              $bgcolor = "#FFCCCC";
         }
         echo '<tr bgcolor="'.$bgcolor.'" align="center" valign="middle">
                      <th scope="col">'.$row['studentID'].'</th>
                      <td>'.$row['firstName'].'</td>
                      <td>'.$row['secondName'].'</td>
                      <td>'.$row['examDate'].'</td>
                      <td>'.$row['moduleNumber'].'</td>
                      <td>Yes</td>
                  </tr>';
         $studPrevious = $row['studentID'];
     }//while loop