$query="select soldierid, hp, attack, defence, range, class, damagetype from soldiers where squad=$squad1 and owner=$playerid";
$result=mysql_query($query);
if (!$result)
{
die (mysql_error());
}
$num_rows=mysql_num_rows($result);
for ($i=0;$i<$num_rows;$i++)
{
$row=mysql_fetch_array($result);
$squad1[$i]['soldierid']=($row['soldierid']);
$squad1[$i]['hp']=($row['hp']);
$squad1[$i]['attack']=($row['attack']);
$squad1[$i]['defence']=($row['defence']);
$squad1[$i]['range']=($row['range']);
$squad1[$i]['class']=($row['class']);
$squad1[$i]['damagetype']=($row['damagetype']);
}

//now for the other squad, squad2
$query="select soldierid, hp, attack, defence, range, class, damagetype from soldiers where squad=$squad2";
$result=mysql_query($query);
if (!$result)
{
die (mysql_error());
}
$num_rows=mysql_num_rows($result);
for ($i=0;$i<$num_rows;$i++)
{
$row=mysql_fetch_array($result);
$squad2[$i]['soldierid']=($row['soldierid']);
$squad2[$i]['hp']=($row['hp']);
$squad2[$i]['attack']=($row['attack']);
$squad2[$i]['defence']=($row['defence']);
$squad2[$i]['range']=($row['range']);
$squad2[$i]['class']=($row['class']);
$squad2[$i]['damagetype']=($row['damagetype']);
}