1 2 3 4 5 6 7 8 9 10 11 12 13
|
$sqla = sprintf("SELECT A.id_adh, A.id_vil, B.id_adh, B.id_log, B.description, B.type, C.id_adh, C.continent, C.pays, C.ville, D.id_log, D.up_nom, E.id_vil, E.id_pay, E.ville, F.id_pay, F.id_con, F.pays_fr, G.cont_fr
FROM flatforswap_adherent A
INNER JOIN flatforswap_logement B ON A.id_adh = B.id_adh
INNER JOIN flatforswap_destination C ON A.id_adh = C.id_adh
INNER JOIN flatforswap_photo D ON B.id_log = D.id_log
INNER JOIN flatforswap_ville E ON A.id_vil = E.id_vil
INNER JOIN flatforswap_pays F ON E.id_pay = F.id_pay
INNER JOIN flatforswap_continent G ON G.id_con = F.id_con
WHERE G.cont_fr= 'Afrique'");
$reqa = mysql_query($sqla) or die('Erreur SQL !<br>'.$sqla.'<br>'.mysql_error()); |
Partager