Bonjour
Je cherche a savoir si on peut joindre c'est deux requêtes ensemble , qui fonctionne bien separemment mais je voudrai savoir comment les joindre si cela est possible , car je n 'arrive pas du tout ,
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14 $q_1= $connec->query ("select id_member, city, round((6371*acos(cos(radians('$lat'))*cos(radians(`latitude`))*cos(radians(`longitude`) -radians('$lon'))+sin(radians('$lat'))*sin(radians(`latitude`)))) , 2) as dist from donnee_connect where (6371*acos(cos(radians('$lat'))*cos(radians(`latitude`))*cos(radians(`longitude`) -radians('$lon'))+sin(radians('$lat'))*sin(radians(`latitude`)))) <= '$searchrange' order by dist, city "); while( $ri = mysqli_fetch_array($q_1)){ $dest_city = $ri["city"]; $dest_membre = $ri["id_member"]; $dist = $ri["dist"]; echo $dest_city; echo $dist; }
et
Code:
1
2
3
4
5
6
7
8
9
10 $q = $connec->query("SELECT * FROM donnee_member INNER JOIN donnee_connect ON donnee_member.id = donnee_connect.id_member INNER JOIN description_member ON donnee_member.id = description_member.id_member_desc WHERE (age BETWEEN '$rangeage[0]' AND '$rangeage[1]') AND (weight_desc BETWEEN '$weightrange[0]' AND '$weightrange[1]') AND (size_desc BETWEEN '$sizerange[0]' AND '$sizerange[1]')"); while( $r = mysqli_fetch_array($q)){ echo 'Résultat de la recherche: '.$r['nom'].' '.$r['prenom'].' '.$r['age'].' <br />'; echo 'Résultat de la ville: '.$r['city'].'<br />'; }