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 php : Sélectionner tout - Visualiser dans une fenêtre à part
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 php : Sélectionner tout - Visualiser dans une fenêtre à part
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 />';
     }