0 ORDER BY pos1,pos2,pos3"; break; case sp: $string = "AND sp > 0 ORDER BY pos1,pos2,pos3"; break; case arc: $string = "AND arc > 0 ORDER BY pos1,pos2,pos3"; break; case lws: $string = "AND lws > 0 ORDER BY pos1,pos2,pos3"; break; case sws: $string = "AND sws > 0 ORDER BY pos1,pos2,pos3"; break; case lms: $string = "AND lms > 0 ORDER BY pos1,pos2,pos3"; break; case sms: $string = "AND sms > 0 ORDER BY pos1,pos2,pos3"; break; case cat: $string = "AND cat > 0 ORDER BY pos1,pos2,pos3"; break; case cs: $string = "AND coly > 0 ORDER BY pos1,pos2,pos3"; break; } $query = mysql_query("SELECT * FROM `isles` $string ") or die(mysql_error()); /* if($_GET['action'] == "src") { highlight_file("index.php"); exit; } */ echo ""; echo ""; $i = 0; $qry = mysql_query("SELECT SUM(stt) from `isles` $string"); $qry = mysql_fetch_array($qry); $total_stt = $qry[0]; $qry = mysql_query("SELECT SUM(sp) from `isles` $string"); $qry = mysql_fetch_array($qry); $total_sp = $qry[0]; $qry = mysql_query("SELECT SUM(arc) from `isles` $string"); $qry = mysql_fetch_array($qry); $total_arc = $qry[0]; $qry = mysql_query("SELECT SUM(lws) from `isles` $string"); $qry = mysql_fetch_array($qry); $total_lws = $qry[0]; $qry = mysql_query("SELECT SUM(sws) from `isles` $string"); $qry = mysql_fetch_array($qry); $total_sws = $qry[0]; $qry = mysql_query("SELECT SUM(lms) from `isles` $string"); $qry = mysql_fetch_array($qry); $total_lms = $qry[0]; $qry = mysql_query("SELECT SUM(sms) from `isles` $string"); $qry = mysql_fetch_array($qry); $total_sms = $qry[0]; $qry = mysql_query("SELECT SUM(cat) from `isles` $string"); $qry = mysql_fetch_array($qry); $total_cat = $qry[0]; $qry = mysql_query("SELECT SUM(coly) from `isles` $string"); $qry = mysql_fetch_array($qry); $total_cs = $qry[0]; $qry = mysql_query("SELECT COUNT(pos1) from `isles` $string"); $qry = mysql_fetch_array($qry); $i = $qry[0]; if ($i % 2 == 0 ) { $colour = "bgcolor=\"#E2E2E2\""; } else { $colour = "bgcolor=\"#F0F0F0\""; } echo ""; echo ""; echo ""; echo ""; $i = 0; while($foo = mysql_fetch_array($query)) { if ($i % 2 == 0 ) { $colour = "bgcolor=\"#E2E2E2\""; } else { $colour = "bgcolor=\"#F0F0F0\""; } echo ""; echo ""; $i++; } ?>

Isle Name	ST	SF	AR	LWS	SWS	LMS	SMS	Catapult	CS
	ST only	SF only	AR only	LWS only	SWS only	LMS only	SMS only	Catapult only	CS only
Total isles: $i	$total_stt	$total_sp	$total_arc	$total_lws	$total_sws	$total_lms	$total_sms	$total_cat	$total_cs
".$foo['name']." (".$foo['pos1'].":".$foo['pos2'].":".$foo['pos3'].")	".$foo['stt']."	".$foo['sp']."	".$foo['arc']."	".$foo['lws']."	".$foo['sws']."	".$foo['lms']."	".$foo['sms']."	".$foo['cat']."	".$foo['coly']."