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
| $_POST["form"]="form_pack1";
$_POST["dept"] = "1";
$_POST["select"]="ville_depart";
$tbNumDept = explode("-", $_POST["dept"]);
$strWhere = " WHERE ";
for($i=0; $i<count($tbNumDept) ; $i++){
$strWhere .= " `ville_dept_id` = '".$tbNumDept[$i]."' OR ";
}
$strWhere = substr($strWhere, 0, strlen($strWhere)-4);
$query = "SELECT ville_id , ville_cp, ville_nom FROM vp_ville ".$strWhere;
$query .= " ORDER BY `ville_id`";
$result = @mysql_query($query);
echo 'var o = null;';
echo 'var s = document.forms["'.$_POST["form"].'"].elements["'.$_POST["select"].'"];';
echo 's.options.length = 0;';
while($r = mysql_fetch_array($result)){
//echo 's.options[s.options.length] = new Option("'.$r['ville_nom'].'");';
//dessus marche pas
echo 's.options[s.options.length] = new Option("'.$r['ville_id'].'");';
//dessus marche
}
@mysql_close($mysql_db); |
Partager