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 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84
|
<p class="double">
<label for="f1-pays" class="oblig"> Continent :
<span class="info"></span></label>
<select name="continent" class="font" onchange="document.forms['form01'].submit();">
<?php
if (empty($continent))
{
echo '<option value="-1" selected="selected">Continent</option>';
}
else
{
echo '<option value="-1">Continent</option>';
}
// on se connecte à MySQL
include ('connect.php');
$sqla = sprintf("SELECT cont_".$lg." FROM flatforswap_continent ORDER BY cont_".$lg." ASC");
$reqa = mysql_query($sqla) or die('Erreur SQL !<br>'.$sqla.'<br>'.mysql_error());
while($dataa = mysql_fetch_assoc($reqa))
{
if ($continent == $dataa['cont_'.$lg.''])
{
echo '<option value="'.$dataa['cont_'.$lg.''].'" selected="selected">'.$dataa['cont_'.$lg.''].'</option>';
}
if ($continent != $dataa['cont_'.$lg.''])
{
echo '<option value="'.$dataa['cont_'.$lg.''].'">'.$dataa['cont_'.$lg.''].'</option>';
}
}
?>
</select>
</p>
<p class="double">
<label for="f1-pays" class="oblig"> Pays :
<span class="info"></span></label>
<select name="ad_pays" class="font" onchange="document.forms['form01'].submit();">
<?php
if (empty($ad_pays))
{
echo '<option value="-1" selected="selected">Choisir</option>';
}
else
{
echo '<option value="-1">Choisir</option>';
// on détermine l'id_con du continent afin de faire la selection des pays du continent
$sqld = sprintf("SELECT id_con FROM flatforswap_continent WHERE cont_".$lg."='".$continent."'");
$reqd = mysql_query($sqld) or die('Erreur SQL : <br />'.$sqld);
$datad = mysql_fetch_assoc($reqd);
$id_con = $datad['id_con'];
$sqlb = sprintf("SELECT pays_".$lg." FROM flatforswap_pays WHERE id_con = '".$id_con."' ORDER BY pays_".$lg." ASC");
// $sqlb = sprintf("SELECT pays_".$lg." FROM flatforswap_pays ORDER BY pays_".$lg." ASC");
$reqb = mysql_query($sqlb) or die('Erreur SQL !<br>'.$sqlb.'<br>'.mysql_error());
while($datab = mysql_fetch_assoc($reqb))
{
if ($ad_pays == $datab['pays_'.$lg.''])
{
echo '<option value="'.$datab['pays_'.$lg.''].'" selected="selected">'.$datab['pays_'.$lg.''].'</option>';
}
if ($ad_pays != $datab['pays_'.$lg.''])
{
echo '<option value="'.$datab['pays_'.$lg.''].'">'.$datab['pays_'.$lg.''].'</option>';
}
}
}
?>
</select>
</p> |
Partager