changing row color

[brown2005]

hi, what i want is to get a set of results from the mysql database and when using

while{



}

i want to change the colors of the rows... one red, one blue, one red, one blue..

thanks

[OOP]

Hi there,
There are several ways for doing this...for example; you can do sothing like this:
[code]$counter = 0;
$result    = 0;
$color    = ' ';
while(....){
  $result = $counter % 2;
  if($result == 0){
      $color = 'red';
  }elseif($result == 1){
      $color = 'blue';
  }
  $counter++;
}[/code]

[brown2005]

$profile = "SELECT * FROM table A;";
$profile_query = mysql_query($profile) or die(mysql_error());
     
$current_price = "";

while($row = mysql_fetch_array($profile_query, MYSQL_ASSOC))
{

    if($row['month'] != $current_price)
    {

echo"<tr>
          <th colspan='4'>".$row['month']."</th>
        </tr>";

    $current_price = $row['month'];

    }

echo"<tr>
  <td>".$row['position']."</td>
  <td>".$row['name']."</td>
  <td>".$row['hits']."</td>
  </tr>";

   
}

Hi, sorry this is what i have currently.. wat i want is for the first row to be class='a' and second row to be class='2', and so on.

how can i work this into the code above, please...

[brown2005]

echo"<tr>
  <td>".$row['position']."</td>
  <td>".$row['name']."</td>
  <td>".$row['hits']."</td>
  </tr>";

this is the bit i want to change class on

[brown2005]

dont worry, ive sorted this now