Switching Loop

[furious5]

I've currently got the following code, which prints out all records in a specified table.

My problem is that I want to switch the style of the table displayed every other record, does anyone know how I could approach this??

do { 
echo"
<table width=100% border=0 cellspacing=0 cellpadding=2>
<tr valign=top> 
<td width=100 rowspan=2><img src=../images/cfc_directors/$row_rsBWDIM[ID].jpg width=100 height=151 alt=$row_rsBWDIM[Name]></td>
<td><strong>$row_rsBWDIM[Name]</strong> </td>
</tr>
<tr> 
<td valign=top><p>$row_rsBWDIM[Description]</p><p><strong>Contact Form - Link</strong></p></td>
</tr>
</table>";

} while ($row_rsBWDIM = mysql_fetch_assoc($rsBWDIM));

[LordShryku]

Just did this lil math function.

<?
for($i=0;$i<100;$i++) {
   if(substr(($i/2),-2) == ".5") {
       // style 1
   }
   else {
      // style 2
   }
}
?>

[furious5]

That does seem to work.

The only problem is that it returns the same record twice, i.e record 1, but doesn't return the next record?

Any ideas??

[LordShryku]

Lemme see how you integrated it into your code. It was meant more as an example of how you could do that....

[furious5]

 

<? 
for($i=0;$i<2;$i++) { 
   if(substr(($i/2),-2) == ".5") { 
       echo"
<table width=100% border=0 cellspacing=0 cellpadding=2>
<tr valign=top> 
<td width=100 rowspan=2><img src=../images/cfc_directors/$row_rsBWDIM[ID].jpg width=100 height=151 alt=$row_rsBWDIM[Name]></td>
<td><strong>$row_rsBWDIM[Name]</strong> </td>
</tr>
<tr> 
<td valign=top><p>$row_rsBWDIM[Description]</p><p><strong>Contact Form - Link</strong></p></td>
</tr>
</table>";

   } 
   else { 
      echo"
<table width=100% border=0 cellspacing=0 cellpadding=2>
<tr valign=top> 
<td width=100 rowspan=2><img src=../images/cfc_directors/$row_rsBWDIM[ID].jpg width=100 height=151 alt=$row_rsBWDIM[Name]></td>
<td><strong>$row_rsBWDIM[Name]</strong> </td>
</tr>
<tr> 
<td valign=top><p>$row_rsBWDIM[Description]</p><p><strong>No contact</strong></p></td>
</tr>
</table>";
   } 
} 
?> 

[LordShryku]

Did you leave the do/while loop in? If so, then you're just looping through a loop. I'd ditch all of that, and do this...

$i=0;
while($row_rsBWDIM = mysql_fetch_array($rsBWDIM)) {
   if(substr(($i/2),-2) == ".5") { 
       echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\">
               <tr valign=\"top\"> 
                 <td width=\"100\" rowspan=\"2\">
                  <img src=\"../images/cfc_directors/".$row_rsBWDIM['ID'].".jpg\" width=\"100\" height=\"151\" 
                   alt=\"".$row_rsBWDIM['Name']."\">
                 </td>
                 <td><strong>".$row_rsBWDIM['Name']."</strong></td>
               </tr>
               <tr> 
                 <td valign=\"top\"><p>".$row_rsBWDIM['Description']."</p>
                                    <p><strong>Contact Form - Link</strong></p>
                 </td>
               </tr>
             </table>";
   } 
   else { 
        echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\">
               <tr valign=\"top\"> 
                 <td width=\"100\" rowspan=\"2\">
                  <img src=\"../images/cfc_directors/".$row_rsBWDIM['ID'].".jpg\" width=\"100\" height=\"151\" 
                   alt=\"".$row_rsBWDIM['Name']."\">
                 </td>
                 <td><strong>".$row_rsBWDIM['Name']."</strong></td>
               </tr>
               <tr> 
                 <td valign=\"top\"><p>".$row_rsBWDIM['Description']."</p>
                                    <p><strong>No contact</strong></p>
                 </td>
               </tr>
             </table>";
   }

   $i++;
}