23 lines
582 B
PHP
23 lines
582 B
PHP
|
<?php
|
||
|
|
require_once($_SERVER['DOCUMENT_ROOT'] . "/config.php");
|
||
|
|
|
||
|
|
if(isset($_POST['temp_region'])) {
|
||
|
|
$regionId = $_POST['temp_region'];
|
||
|
|
$sql = "
|
||
|
|
SELECT * FROM builders WHERE id IN (
|
||
|
|
SELECT builder_id FROM blocks
|
||
|
|
INNER JOIN regions re ON re.id = blocks.region_id
|
||
|
|
WHERE blocks.id IN (select block_id from apartments)
|
||
|
|
AND re.rf_region_id = $regionId
|
||
|
|
) ORDER BY name
|
||
|
|
";
|
||
|
|
|
||
|
|
$rez = mysql_query($sql);
|
||
|
|
|
||
|
|
if (mysql_num_rows($rez) > 0) {
|
||
|
|
while($dbObject = mysql_fetch_assoc($rez)) {
|
||
|
|
echo "<option value='$dbObject[id]'>$dbObject[name]</option>";
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|