Php > Look and Feel

Another Alternate Row color

Another Alternate Row color

<?php 

// Displays alternate table row colors 
function row_color($i){ 
    $bg1 = "#0099FF"; // color one     
    $bg2 = "#336699"; // color two 

    if ( $i%2 ) { 
        return $bg1; 
    } else { 
        return $bg2; 
    } 
} 

//DB connection 
$connection = mysql_connect("localhost","userName","password"); 
$db = mysql_select_db("databaseName"); 

$sql = "select * from tableName";      // Database Query   
$result = mysql_query("$sql");  // Database Query result 

// Starts the table 
echo "<table bgcolor=#FFFFFF border=0 cellpadding=1 cellspacing=1>\n"; 

// Create the contents of the table. 
for( $i = 0; $i < $row = mysql_fetch_array($result); $i++){ 
    echo "<TR>\n" 
        ."<TD bgcolor=".row_color($i).">".$row["fname"]."</TD>\n" 
        ."<TD bgcolor=".row_color($i).">".$row["lname"]."</TD>\n"         
        ."</TR>"; 
} 
echo "</TABLE>" 
?>