[RESOLVED] row colour

verN

I have a table and would like the row to change colours. The table uses two colours white and green. The frist row in the table should be green then white then green then white and so on.

How would i go about doing this thanks. I am using while() tio get the rows and storing it in a variable

thanks in advance

Flyier

Something like that :

 <?php


print ("<body>");
print ("<table border=1 width=100%>
<tr>
<td width=18%><font face=Verdana, Arial, Helvetica, sans-serif size=2><b>Link</b></font></td>
<td width=82%><font face=Verdana, Arial, Helvetica, sans-serif size=2><b>ID</b></font></td>");


$connection = mysql_connect("localhost","user","password");
$db = mysql_select_db("test", $connection);


$sql = mysql_query("SELECT * FROM test");

$alternate = "2"; 
while ($row = mysql_fetch_array($sql)) {
$name = $row["link_name"]; 
$id = $row["link_id"];

if ($alternate == "1") {
$colour = "white"; 
$alternate = "2";
}

else {
$colour = "#66FF66"; 
$alternate = "1";
}

print ("</tr><tr><td bgcolor=$colour width=18%><font face=Verdana, Arial, Helvetica,
sans-serif size=2>$name</font></td><td bgcolor=$colour width=82%>
<font face=Verdana, Arial, Helvetica, sans-serif size=2>$id</font></td>
</tr>");
}
print ("</table>");

?>

Here is a demo

Installer

Here's a method that's simpler and uses styles:

$color_array = array('white', 'green');
$color_index = 0;

echo '<table>';
while ($row = mysql_fetch_array($sql)) {
    $color_index = !$color_index;
    echo '<tr style="background-color : ' . $color_array[$color_index] . '">'
       . '<td>' . $row['link_name'] . '</td><td>' . $row['link_id'] . '</td>'
       . '</tr>';
}
echo '</table>';

Search the forums for "alternate colors" and you'll find even more methods.