[SOLVED] alternating bgcolor on table rows

[dennismonsewicz]

I am having a difficult time in trying to get the alternating background color to work.

 

foreach($search_rows as $row) {
    			$numrows = count($row);
    			
    			for($i = 0; $i < $numrows; $i++) {
    				if (($i % 2) == 0) {
				 $alt = "d4e4fe";
				} else {
				 $alt = "bfd4f8";
				}
    			
    			echo '<tr bgcolor="#' . $alt . '">';
    				echo '<td>' . $row->branch_name . '</td>';
    				echo '<td>' . $row->address . '</td>';
    				echo '<td>' . $row->city . '</td>';
    				echo '<td>' . $row->state . '</td>';
    				echo '<td>' . $row->zip . '</td>';
    				echo '<td>' . format_phone($row->phone_number) . '</td>';
    			echo '</tr>';
    			}
    		}

[Ken2k7]

What you want to do is put the count outside of the loop. And I don't think $row is an array.

 

Also, I'm not sure if bgcolor works on <TR> tag. But if it does, try this -

 

$row = 0;
foreach($search_rows as $row) {
     $alt = (++$row % 2 == 0)? 'd4e4fe' : 'bfd4f8';
     echo '<tr bgcolor="#' . $alt . '">';
     echo '<td>' . $row->branch_name . '</td>';
     echo '<td>' . $row->address . '</td>';
     echo '<td>' . $row->city . '</td>';
     echo '<td>' . $row->state . '</td>';
     echo '<td>' . $row->zip . '</td>';
     echo '<td>' . format_phone($row->phone_number) . '</td>';
     echo '</tr>';
}

[dennismonsewicz]

Hmmmm.... all that did was do the same thing it has been doing and set the whole table to one color.

 

updated code:

 

$row = 0;
	foreach($search_rows as $row) {
		$alt = ($row % 2 == 0)? 'd4e4fe' : 'bfd4f8';
			echo '<tr>';
			echo '<td bgcolor="#' . $alt . '">' . $row->branch_name . '</td>';
			echo '<td bgcolor="#' . $alt . '">' . $row->address . '</td>';
			echo '<td bgcolor="#' . $alt . '">' . $row->city . '</td>';
			echo '<td bgcolor="#' . $alt . '">' . $row->state . '</td>';
			echo '<td bgcolor="#' . $alt . '">' . $row->zip . '</td>';
			echo '<td bgcolor="#' . $alt . '">' . format_phone($row->phone_number) . '</td>';
			echo '</tr>';
	}

[Brian W]

You need to increment $row

$row = 0;
      foreach($search_rows as $row) {
         $alt = ($row % 2 == 0)? 'd4e4fe' : 'bfd4f8';
            echo '<tr>';
            echo '<td bgcolor="#' . $alt . '">' . $row->branch_name . '</td>';
            echo '<td bgcolor="#' . $alt . '">' . $row->address . '</td>';
            echo '<td bgcolor="#' . $alt . '">' . $row->city . '</td>';
            echo '<td bgcolor="#' . $alt . '">' . $row->state . '</td>';
            echo '<td bgcolor="#' . $alt . '">' . $row->zip . '</td>';
            echo '<td bgcolor="#' . $alt . '">' . format_phone($row->phone_number) . '</td>';
            echo '</tr>';
            $row++;
      }

[Ken2k7]

Sorry, I noticed that and edited the code. Apparently you got in too soon. See my above code again.

[dennismonsewicz]

here is my updated code... when i implemented this all of the backgrounds are white and not alternating...

 

$row = 0;
      foreach($search_rows as $row) {
         $alt = ($row % 2 == 0)? 'ff0000' : 'ffffff';
            echo '<tr>';
            echo '<td bgcolor="#' . $alt . '">' . $row->branch_name . '</td>';
            echo '<td bgcolor="#' . $alt . '">' . $row->address . '</td>';
            echo '<td bgcolor="#' . $alt . '">' . $row->city . '</td>';
            echo '<td bgcolor="#' . $alt . '">' . $row->state . '</td>';
            echo '<td bgcolor="#' . $alt . '">' . $row->zip . '</td>';
            echo '<td bgcolor="#' . $alt . '">' . format_phone($row->phone_number) . '</td>';
            echo '</tr>';
            $row++;
      }

[dennismonsewicz]

Bump

[Ken2k7]

I am stupid. Sorry for setting a bad example.

 

$count = 0;
foreach($search_rows as $row) {
     $alt = (++$count % 2 == 0)? 'd4e4fe' : 'bfd4f8';
     echo '<tr bgcolor="#' . $alt . '">';
     echo '<td>' . $row->branch_name . '</td>';
     echo '<td>' . $row->address . '</td>';
     echo '<td>' . $row->city . '</td>';
     echo '<td>' . $row->state . '</td>';
     echo '<td>' . $row->zip . '</td>';
     echo '<td>' . format_phone($row->phone_number) . '</td>';
     echo '</tr>';
}

[dennismonsewicz]

Awesome! This works! TKS!