1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| <?php
$sql = "SELECT gv.membres_id, gv.ville, gv.pays, gv.photo, gv.date_naissance, gv.message, gv.date_inscription,
p.membres_id, p.ville, p.pays, p.date_naissance, p.photo, p.date_inscription, m.id, m.login
FROM membres AS m
INNER JOIN grey_victory AS gv ON gv.membres_id = m.id
INNER JOIN passenger AS p ON P.membres_id = m.id";
$data = mysql_query($sql) or die('Erreur - tables jointures: ' . mysql_error());
while($info = mysql_fetch_array($data, MYSQL_BOTH )) {
$info = mysql_fetch_assoc($data);
echo ($info['membres_id']);
}
?> |
Partager