<?php 

$id = 3;



$ressource = mysql_query("

                    SELECT o.id, o.nom

                    FROM session AS s

                    LEFT JOIN inventaire AS i

                        ON i.personage = s.id

                    LEFT JOIN objet AS o

                        ON o.id = i.objet

                    WHERE s.id = ".$id."

                    AND o.type = 'arme'

                ") or die (mysql_error());









if(mysql_num_rows($ressource) <= 0)

{

    echo "Vous n'avez pas d'objet";

}else

{

    echo '<form method="post" action="traitement_changement_equipement.php"><p>Main droite : ';

    echo '<select name="main_droite">';



    while($donnee = mysql_fetch_assoc($ressource))

    { 

        echo '<option value="'.$donnee['nom'].'">'.$donnee['nom'].'</option>';

    }



    echo '</select>';

}