Mysql 2 post

[jnich104]

how to i make it so that every second post is differnet

like

PHP Code:

$connect = mysql_connect('asd','asd','asd');

Blah Blah Blah

while($row = mysql_fetch_array($result))
      {
        echo '<div class="1">'.$row['show_date'].'</div>' ;
      } 


But then for post number 2,4,6,8,10 ect..

something like

PHP Code:

$connect = mysql_connect('asd','asd','asd');

Blah Blah Blah

while($row = mysql_fetch_array($result))
      {
        echo '<div class="2">'.$row['show_date'].'</div>' ;
      } 


Class number changed



Anyone got a idea?

[sde]

PHP Code:

<?php
// initialize your iterator
$i=0;

// loop through result set
while ($row = db_fetch_array($result)) {

  // use the modulus operator to get the remainder of the iterator divided by 2
  // even numbers will always have a remainder of 0 when divided by 2
  $class = $i%2==0?'even':'odd';

  // echo your div with your new class
  echo '<div class="'. $class .'">'. $row['show_date'] .'</div>';

  // increment your iterator
  $i++;
}
?>

[jnich104]

Thanks