\n\t\n\t$a1[BannerFile]\n\t"; //get the total clicks $q2 = "select sum(clicks) as myclicks, sum(impressions) as myimpres from yellow_stats where BannerID = '$a1[BannerID]' "; $r2 = mysql_query($q2) or die(mysql_error()); $a2 = mysql_fetch_array($r2); $btable .= "$a2[myimpres]\n\t$a2[myclicks]\n\t"; if($a2[myimpres] > '0') { $rato = number_format(($a2[myclicks]/$a2[myimpres]) * 100, 2, ".", ""); } else { $rato = '0.00'; } $btable .= "$rato %\n\n\n"; } //get the templates require_once("templates/HeaderTemplate.php"); require_once("templates/BannerIndex.php"); require_once("templates/FooterTemplate.php"); ?>