$sql = 'SELECT `pf_alliance`,`pf_strike`,`pf_defense`,`pf_covert`,`pf_assassin`,`pf_gameid` FROM `phpbb_aw_profile_fields_data` WHERE `pf_alliance` = "Marauders"';
$sql2 = mysql_query($sql) or die(mysql_error());

$atkp = array();
$defp = array();
$covp = array();
$asnp = array();

$x = 0;

while ($adata = mysql_fetch_assoc($sql2)) {

$poop = 'SELECT `atka`,`defa`,`cova`,`assa`,`atksup`,`atkmerc`,`defsup`,`defmerc`,`spies`,`assassin` FROM awuptodate WHERE id = '.$adata[pf_gameid];
$poop2 = mysql_query($poop) or die(mysql_error());
$statdata = mysql_fetch_assoc($poop2);

$atkp[$x] = floor($statdata[atka] / ( $statdata[atksup] + $statdata[atkmerc] ));
$defp[$x] = floor($statdata[defa] / ( $statdata[defsup] + $statdata[defmerc] ));
$covp[$x] = floor($statdata[cova] / $statdata[spies]);
$asnp[$x] = floor($statdata[assa] / $statdata[assassin]);

$x++

}