Membres de l'axe 1 (OAaCN)
{source}
<?php
$link = mysqli_connect("localhost", "mathstic", "math2013!;", "applications");/* Vérification de la connexion */
if (mysqli_connect_errno()) {
printf("Échec de la connexion : %s\n", mysqli_connect_error());
exit();
}$query = "SELECT Nom, Prenom FROM individus I, membres M where I.mail = M.individu and M.liste = This email address is being protected from spambots. You need JavaScript enabled to view it.' order by nom";
if ($result = mysqli_query($link, $query)) {/* Récupère un tableau d'objets */
while ($obj = mysqli_fetch_object($result)) {
echo "<b>".ucwords(strtolower(htmlentities($obj->Nom)))."</b> ".ucwords
(strtolower(htmlentities($obj->Prenom)))
."<br>";
}/* free result set */
mysqli_free_result($result);
}/* Fermeture de la connexion */
mysqli_close($link);
?>
{/source}