<?php
include(‘dbconnect.php’);
$query1 = “SELECT * FROM clients_info order by fname asc”;
$r1 = mysql_query($query1) or die(‘Error, query1 failed to retrieve information from client_info table’);
$color1 = ‘#90EE90′;
$color2 = “#CCFFCC”;
$row_count = 0;
while($row = mysql_fetch_array($r1))
{
$color = ($row_count % 2) ? $color1 : $color2;
print'<div id=”clients_name” style=”background-color:’ . $color . ‘”>’;
print”{$row[‘fname’]} {$row[‘lname’]}<br/>”;
print'</div>’;
$row_count++;
}
?>