<?php
$team=safe_query("SELECT * FROM ".PREFIX."squads ORDER BY RAND() LIMIT 0,1");
if(mysql_num_rows($team)) {
while($dn=mysql_fetch_array($team)) {
$squadID=$dn['squadID'];
$squadname=$dn['name'];
?>
<div class="team" style="height:100px;">
<ul>
<?php
$member=safe_query("SELECT * FROM ".PREFIX."squads_members WHERE squadID=$squadID");
if(mysql_num_rows($member)) {
while($ds=mysql_fetch_array($member)) {
echo '<li style="width:85px; height:100px;"><a href="index.php?site=profile&id='.$ds['userID'].'"><img src="images/userpics/'.getuserpic($ds['userID']).'" border="0" alt="" /></a></li>';
}
}
else echo 'Keine Member im Squad';
?>
</ul>
</div>
<?php
}
}
else echo'kein Squad';
?>
