1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
if($continent != "-1" and $ad_pays != "-1" and $ville != "-1"){
$sqlc = $db->prepare("SELECT MAX(pers) as persmax
FROM flatforswap_logement A
INNER JOIN flatforswap_adherent B ON A.id_adh = B.id_adh
INNER JOIN flatforswap_ville C ON B.id_vil = C.id_vil
INNER JOIN flatforswap_pays D ON C.id_pay = D.id_pay
INNER JOIN flatforswap_continent E ON D.id_con = E.id_con
WHERE E.cont_".$lang."=? and D.pays_".$lang."=? and C.ville_fr=?");}
$sqlc->execute(array($continent, $ad_pays, $ville));
$donnees = mysql_fetch_array($sqlc);
$persmax = $donnees['persmax'];
for($i=1;$i < ($persmax + 1);$i++)
{
echo '<OPTION value='.$i.'">'.$i.'</option>';
} |
