Alternating table colors for rows and columns.

ellisgl (Kenneth Ellis McCall) — Fri, 10 Aug 2007 16:59:53 GMT

This code will provide 8 colors for cells and set of 8 lighter colors for alternating rows.



$sql  = 'SELECT * FROM `table` WHERE `column` = \'something\'';

$qry = mysql_query($sql) or die(mysql_error());



// Cell colors for odd rows

$c1  = array('#00CCCC', '#33CC00', '#CC0000', '#CCCC00', '#0000CC', '#FF6600', '#CC00CC', '#00CC99');



// Cell Colors for even rows

$c2  = array('#66FFFF', '#66FF00', '#FF3300', '#FFFF33', '#0033FF', '#FF9933', '#FF33CC', '#00FF99');



// Row Counter

$cnt  = 0;



$ret = '';

while($row = mysql_fetch_assoc($qry))

{

  // Cell counter

  $cnt2 = 0;

  $ret  .= '';

  foreach($row as $key=>$val)

   {

    $ret .= '';

    ++$cnt2;

   }

  ++$cnt;

  $ret .= ''."\n";

}

$ret .= ''.$val.'';



echo $ret;

?>

DZone Snippets: Cells code

Alternating table colors for rows and columns.