Sure … it really consists of 2 pages form.php & get_models.php here they are
Form.php
[code]
<?php
require_once 'config.php'; // for database connection to be removed later
$query = "SELECT `make` , COUNT(`make`) AS makeCount FROM vehicles GROUP BY `make` ORDER BY `make` ASC;";
$result = mysql_query($query);
$resultCount =0;
$arrMake= array();
if($result){
while($row = mysql_fetch_assoc($result)){
$resultCount = $resultCount + $row['makeCount'];
if($resultCount){
$make = array(
'make' => $row['make'],
'makeCount' => $row['makeCount'],
);
//$arrMake[] = $row['make'].' ('.$row['makeCount'].')';
$arrMake[] = $make;
}
}
//print_r($arrMake);
}
?>
<fieldset>
<div class="stock"><span id='dynamicStockCount'></span> Vehicles in stock</div>
<span id='originalCount' style='display:none'><?php echo $resultCount;?></span>
</fieldset>
<fieldset>
<label>Manufacturer:</label>
<select name="make" id="drop_1" style="width:260px">
<option value="" id="" selected="selected" disabled="disabled">Make</option>
<?php foreach($arrMake AS $make){
?>
<option value="<?php echo $make['make']?>" id='<?php echo $make['makeCount'];?>' >
<?php echo $make['make'].' ('.$make['makeCount'].')';?>
</option>
<?php
}
?>
</select>
</fieldset>
<fieldset>
<label>Model:</label>
<span style="display: inline;" id="result_1">
<span id="wait_1" style="display: none;">
<img alt="Please Wait" src="images/ajax-loader.gif">
</span>
<select name="model" id="tier_two" style="width:260px">
<option value=" " disabled="disabled" selected="selected">Choose one</option>
<!-- <option value="FIESTA HATCHBACK">FIESTA HATCHBACK</option> -->
</select>
</span>
</fieldset>
<fieldset>
<label>Min Price:</label>
<select id="minPrice" name="minPrice">
<option value="0">No min</option>
<option value="500">£500</option>
<option value="1000">£1,000</option>
<option value="2000">£2,000</option>
<option value="3000">£3,000</option>
<option value="4000">£4,000</option>
<option value="5000">£5,000</option>
<option value="6000">£6,000</option>
<option value="7000">£7,000</option>
<option value="8000">£8,000</option>
<option value="9000">£9,000</option>
<option value="10000">£10,000</option>
<option value="12000">£12,500</option>
<option value="15000">£15,000</option>
<option value="17000">£17,500</option>
<option value="20000">£20,000</option>
<option value="25000">£25,000</option>
<option value="30000">£30,000</option>
<option value="35000">£35,000</option>
<option value="40000">£40,000</option>
<option value="45000">£45,000</option>
<option value="50000">£50,000</option>
<option value="75000">£75,000</option>
<option value="100000">£100,000</option>
<option value="250000">£250,000</option>
<option value="500000">£500,000</option>
</select>
</fieldset>
<fieldset>
<label>Max Price:</label>
<select id="maxPrice" name="maxPrice">
<option value="0">No max</option>
<option value="500">£500</option>
<option value="1000">£1,000</option>
<option value="2000">£2,000</option>
<option value="3000">£3,000</option>
<option value="4000">£4,000</option>
<option value="5000">£5,000</option>
<option value="6000">£6,000</option>
<option value="7000">£7,000</option>
<option value="8000">£8,000</option>
<option value="9000">£9,000</option>
<option value="10000">£10,000</option>
<option value="12000">£12,500</option>
<option value="15000">£15,000</option>
<option value="17000">£17,500</option>
<option value="20000">£20,000</option>
<option value="25000">£25,000</option>
<option value="30000">£30,000</option>
<option value="35000">£35,000</option>
<option value="40000">£40,000</option>
<option value="45000">£45,000</option>
<option value="50000">£50,000</option>
<option value="75000">£75,000</option>
<option value="100000">£100,000</option>
<option value="250000">£250,000</option>
<option value="500000">£500,000</option>
<option value="1000000">£1,000,000</option>
</select>
</fieldset>
<div class="clear">
</div>
<button id="submitSearch" class="submit-search" type="submit">
Search
</button>
[/code]
get_models.php
[code]<?php
header(‘content-type: application/json; charset=utf-8’);
require_once(‘config.php’);//for db connection to be removed later
$arrResponse = array();
if(isset($_REQUEST[‘make’])){
$make = $_REQUEST[‘make’];
$query = "SELECT `model` , COUNT(`model`) AS modelCount FROM vehicles WHERE `make`= '$make' GROUP BY `model` ORDER BY `model` ASC;";
//echo $query;
$result = mysql_query($query);
$resultCount =0;
$arrModel= array();
if($result){
while($row = mysql_fetch_assoc($result)){
$resultCount = $resultCount + $row['modelCount'];
if($resultCount){
$model = array(
'model' => $row['model'],
'modelCount' => $row['modelCount'],
);
$arrModel[] = $model;
}
}
$arrResponse['success'] = TRUE;
$arrResponse['data'] =$arrModel ;
}
else{
$arrResponse['success'] = FALSE;
}
}
else{
$arrResponse[‘success’] = FALSE;
}
echo json_encode($arrResponse);
?>[/code]