<?php echo $rows[$alliance_id];?>

<?php 

$reponse4 = mysql_cquery('SELECT Nom FROM alliance');



$i=0;

while ($donnees2 = mysql_fetch_array($reponse4) )

{

$rows[$i]=$donnees2['Nom'];

$i=$i+1;

} 

<?php 

$reponse4 = mysql_cquery('SELECT id,Nom FROM alliance WHERE id='$reponse4' AND nom = '$nom'''); 

<?php 

$requette = "SELECT nom,prenom,id,alliance FROM ta_table WHERE pseudo = '$pseudo'";

$sql = mysql_query($requette);

$result = mysql_fetch_assoc($sql);



while ($row = mysql_fetch_assoc($result)) {

    echo $row['nom'];

    echo $row['prenom'];

    echo $row['id'];

    echo $row['alliance'];

}