1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
$sqla = sprintf("SELECT A.id_adh, A.id_vil, B.id_adh, B.id_log, B.description, 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
WHERE G.cont_fr='EUROPE' AND A.id_adh=4");
echo $sqla;
$reqa = mysql_query($sqla) or die('Erreur SQL !<br>'.$sqla.'<br>'.mysql_error());
// echo $reqa;
echo 'nombre ='.mysql_num_rows($reqa);
$dataa = mysql_fetch_assoc($reqa);
$description == $dataa['description'];
echo 'description ='.$description; |
Partager