<?php
$sel = $mysql->select(PRE.'affiliates', "status='yes'", "id");
echo '<table style="width:50%; text-align:center; margin-left: 25%;">';
$rows = mysql_num_rows($sel);
for($i=0;$i<$rows;$i++)
{
	if($i % 2)
	{
		$style = "row1";
	} else {
		$style = "row2";
	}
	$a = mysql_fetch_assoc($sel);
	echo '<tr class="'.$style.'"><td style="width:90px;"><a href="out/'.$a["id"].'/"><img src="'.$a["button"].'" alt="'.$a["sitename"].'" /></a></td><td><a href="out/'.$a["id"].'/">'.$a["sitename"].'</a><br />Clicks in: '.$a["clicksin"].' | Clicks out: '.$a["clicksout"].'</td></tr>'."\n";
}
echo "</table>";