Here is a sample php script, upload it to your server and test:
[PHP]<?php
//this is a sample result set, you should replace it with your SQL query results
$results=array("result 1", "result 2", "result 3", "result 4", "result 5");
$odd=true;
foreach ($results as $r) {
if ($odd) {$listClass='odd';}
else {$listClass='even';}
$odd=!$odd;
$list.='<li class="'.$listClass.'">'.$r.'</li>';
}
?>
<html>
<head>
<style>
li {margin:10px 0;}
.odd {background:#ccc;}
.even {background:#ddd;}
</style>
</head>
<body>
<ul>
<?php echo $list; ?>
</ul>
</body>
</html>[/PHP]
