[Resolved] Rotating Background Colors

[cmccomas]

Hello all, I'd like to be able to have the results of the PHP alternate background color in my loop, but I am not sure how to accomplish this, below is a copy of the normal code I use in my loop.

So, if there are five results outputted, I'd like the loop to do the background color:
#CCCCCC
#FFFFFF
#CCCCCC
#FFFFFF
#CCCCCC

Thanks!

if (mysql_num_rows($result) > 0)
									{
										// iterate through resultset
										// print article titles
										while($row = mysql_fetch_object($result))
										{
										?>
								<tr>
									<td width="10" align="right"></td>
									<td width="220" align="left" valign="top"><b><a href="news.php?newsID=<?php echo $row->newsID; ?>" class="link-news"><? echo $row->news_headline; ?></a></b><font class="text-date"> [<? echo $row->news_date; ?>]</font></td>
								</tr>
								<?
										}
									}
									// if no records present
									// display message
									else
									{
									?>
										<font size="-1">no news items currently available</font>
									<?

[drew010]

you can only have one background color for your webpage. if you wish to change it at a given interval to another solid color, you need to use javascript and create a js array in the page output, at every x seconds change the document.bgColor property to change the color.

[cmccomas]

Actually, this is for a table.

I have news headlines outputted in a table and each headline has its own row in the table. I want the table rows to rotate background colors.

So, the table would be:

<tr>
 <td bgcolor="#cccccc">News Item 1</td>
</tr>
<tr>
 <td bgcolor="#ffffff">News Item 2</td>
</tr>
<tr>
 <td bgcolor="#cccccc">News Item 3</td>
</tr>
<tr>
 <td bgcolor="#ffffff">News Item 4</td>
</tr>
<tr>
 <td bgcolor="#cccccc">News Item 5</td>
</tr>

Sorry for the confusion.

[drew010]

use modulus then inside the loop.

if ($i % 2 == 0) {
//use bgcolor 1
} else {
//use bgcolor 2
}
$i++;

[cmccomas]

So, the new loop would be:

if (mysql_num_rows($result) > 0) 

if ($i % 2 == 0) { 
//use bgcolor 1 
} else { 
//use bgcolor 2 
} 
$i++;

  { 
   // iterate through resultset 
   // print article titles 
     while($row = mysql_fetch_object($result)) 
          { 
?> 
<tr> 
<td width="100" align="right"></td> 
</tr>

Is that right?

[drew010]

you will probably want to put it in the while loop at the same point where you output <td bgcolor="#cccccc">News Item 1</td>

[cmccomas]

drew, I'm really lost on this...I mentioned in another post I know a bit of PHP, but not alot, so bare with me.

Is this right?

if (mysql_num_rows($result) > 0)  

  {  

   // iterate through resultset 
   // print article titles 
     while($row = mysql_fetch_object($result))  

          {  

if ($i % 2 == 0) {  

#cccccc
} else {  

#ffffff
}  

$i++; 

?>  

<tr> 
<td width="100" align="right"></td> 
</tr>

[drew010]

yeah that looks about right. id really have to see the whole snipped where the <td>'s are output but that is the idea there that you have.

[cmccomas]

drew, thanks.

What do I need to include in the <td> tags, if anything, to make sure the bgcolor is there, anything?

Here's the complete code I use to display the information.

<? 
   // includes 
   include("conf.php");

   // open database connection 
    $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 

// select database 
mysql_select_db($db) or die ("Unable to select database!"); 

// generate and execute query 
$query = "SELECT newsID, news_headline, date_format(news_date, '%c.%d.%y')as news_date FROM news ORDER BY newsID DESC LIMIT 0, 7"; 

 $result = mysql_query($query) or die ("Error in query: $query. " . mysql_error()); 

 // if records present
 if (mysql_num_rows($result) > 0)
  {
    // iterate through resultset
    // print article titles
    while($row = mysql_fetch_object($result))
      {
        if ($i % 2 == 0) {   
       #cccccc 
       } else {   
       #ffffff 
       }   
       $i++;
       ?>
          <tr>
                 <td><a href="/news.php?newsID=<?php echo $row->newsID; ?>" class="link-news"><? echo $row->news_headline; ?></a></b><font class="text-date"> [<? echo $row->news_date; ?>]</font></td>
          </tr>
       <?
}
             }
  // if no records present
     else
       {
                  ?>
                <font size="-1">no news items currently available</font>
					        <?
}
// close database connection
mysql_close($connection);
?>

Am I right, or close?

[drew010]

in the while loop try this:

               <tr>
 if ($i % 2 == 0) {   

           $color = "#cccccc";
           } else {   

           $color = "#ffffff";
           }   

           $i++;
           ?>
                     <td bgcolor="<?php echo $color; ?>"><a href="/news.php?newsID=<?php echo $row->newsID; ?>" class="link-news"><? echo $row->news_headline; ?></a></b><font class="text-date"> [<? echo $row->news_date; ?>]</font></td> 

[cmccomas]

Thanks drew.