проблем със select

[zaraan]

$q = "SELECT * FROM city ORDER BY id;";
$r = dbGet($q);

foreach($r as $k => $v) {
$city .= " <option value=\"". $v['name_city'] ."\">". $v['name_city'] ."</option>";

}

$raions = '';
if(isset($_POST['city']) && ($_POST['city']) > 0) {

$q1 = "SELECT * FROM raion WHERE id_city='" . $v['id'] . "' ORDER BY id_r;";
$r1 = dbGet($q1);
foreach($r1 as $k1 => $v1) {
$raions .= " <option value=\"". $v1['name_r'] ."\">". $v1['name_r'] ."</option>";
}
}
$podraions = '';
if(isset($_POST['raion']) && ($_POST['raion']) > 0) {
$q2 = "SELECT * FROM podraion WHERE id_raion='" . $v1['id_r'] . "' ORDER BY id_p;";
$r2 = dbGet($q2);

foreach($r2 as $k2 => $v2) {
$podraions .= " <option value=\"". $v2['name_podr'] ."\">". $v2['name_podr'] ."</option>";
}
}
if($raions == '') {
$raions = 'n/a';
}
if($podraions == '') {
$podraions = 'n/a';
}

$site .= " <fieldset><legend>Въвеждане на обява</legend>\n";
$site .= " <form action=\"index.php?m=" . $m . "&style=" . $style . "\" method=\"post\" enctype=\"multipart/form-data\">\n";

$site .= " <input type=\"hidden\" name=\"update\" value=\"" . ((isset($_GET['upd'])) ? $_GET['upd'] : '') . "\" />\n";
$site .= " <p>Категория<br />\n";
$site .= "<select class=\"inp\" type=\"text\" name=\"vid_sd\" value=\"" . ((isset($_POST['vid_sd'])) ? $_POST['vid_sd'] : '') . "\" ><option value=\"0\" selected=\"selected\">--</option>
<option value=\"Продажба\">Продажба</option>
<option value=\"Наем\">Наем</option>

</select>" . $evid_sd . "\n";


$site .= " <p>Град/Област<br />\n";
$site .= " </p>\n";
$site .= "<select class=\"inp\" type=\"text\" name=\"city\" value=\"" . ((isset($_POST['city'])) ? $_POST['city'] : '') . "\" onChange=\"this.form.submit()\" >
<option value=\"0\" selected=\"selected\">Изберете град/област</option>\n";
$site .=$city;
$site .= "</select>" . $ecity . "\n";

$site .= " </p>\n";

$site .= " <p>Район<br />\n";
$site .= " </p>\n";
$site .= "<select class=\"inp\" type=\"text\" name=\"raion\" value=\"" . ((isset($_POST['raion'])) ? $_POST['raion'] : '') . "\" >
<option value=\"0\" selected=\"selected\">Изберете район</option>\n";

$site .=$raions;


$site .= "</select>" . $eraion . "\n";
$site .= " </p>\n";
$site .= " </p>\n";
$site .= " </p>\n";
$site .= "<select class=\"inp\" type=\"text\" name=\"city\" value=\"" . ((isset($_POST['podraion'])) ? $_POST['podraion'] : '') . "\" >
<option value=\"0\" selected=\"selected\">Изберете подрайон</option>\n";

$site .=$podraions;


$site .= "</select>" . $epodraion . "\n";
$site .= " </p>\n";
Как да направя като се избере напр. София да показва кварталите и после в зависимост от квартала да показва улиците.

 

[crazy_pi4]

http://www.dynamicdrive.com/dynamicindex1/chainedmenu/index.htm