<?php
$name=$_GET['name'];
require_once ('config.php');
$cerereSQL = 'SELECT * FROM utilizatori WHERE utilizator="'.$_SESSION['user'].'" ';
$rezultat = mysql_query($cerereSQL);
while($rand = mysql_fetch_array($rezultat)) {
	$nume=$rand['alianta'];
}
if($name == $nume) {
$q=mysql_query("SELECT * FROM `utilizatori` where alianta='$name'");
 echo'</table><center>
<p><table width="440" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td width="440" height="31"><h1><span class="style4"><u><center>'.$nume.'</h1></td>
  </tr>
  </table>
<table width="440" border="0" bgcolor="#666666" class="tabel">
  <tr>
<td width="17%" bgcolor="#BBE528"><center>
<b><u>Nr:</u></b>
</center></td>
<td width="29%" bgcolor="#BBE528"><center>
  <b><u>Membri:</u></b>
</center></td>
<tr>';
 while($r = mysql_fetch_array($q)){
$utilizator=$r['utilizator'];
$i=0;
$i++;
//echo $utilizator.' <br />';


echo'<td width=\"22%\" bgcolor=6666FF><center><b>'.$i.'</b></center></td>
<td width=\"55%\" bgcolor=6666FF><b><center>'.$utilizator.'</b></td>
</tr>';
 }
echo' </table>';
}
else { echo 'nu esti in alianta!!';}

?>