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
|
if (empty($fac))
{
echo '<option value="-1" selected="selected">'.$idem_txt0017.'</option>';
}
else
{
echo '<option value="-1">'.$idem_txt0017.'</option>';
}
// requête de jointure entre la table pays et la table ville
$sqlba = $db->prepare("SELECT vl.fac FROM flatforswap_fac vl INNER JOIN flatforswap_ville py ON py.id_vil = vl.id_vil WHERE py.ville_fr = ? ORDER BY vl.fac ASC");
$sqlba->execute(array($ville));
while($databa = $sqlba->fetch())
{
if ($fac == $databa['fac']) // ici Undefined variable: fac
{
echo '<option value="'.$databa['fac'].'" selected="selected">'.$databa['fac'].'</option>';
}
if ($fac != $databa['fac']) // ici Undefined variable: fac
{
echo '<option value="'.$databa['fac'].'">'.$databa['fac'].'</option>';
}
} |