<?php
/**
* File: /path/to/webroot/properties/search.php
*/
include('init.php');
// Get the list of cities
$query = "SELECT id, name FROM cities";
foreach ($dbh->query($query) as $row) {
$viewVars['cities'][$row['id']] = $row['name'];
}
// Render the view
render('search');

<form action="advanced_search.php" method="post">
<fieldset>
<legend>Advanced search</legend>
<div class="input">
<label>City: </label>
<select name="city_id">
<?php foreach ($viewVars['cities'] as $id => $name):?>
<option value="<?php echo $id; ?>">
<?php echo $name; ?></option>
<?php endforeach; ?>
</select>
</div>
<div class="input">
<label>Type: </label>
<input type...