AutoSuggest Results Filtered via Drop Down

[mfdesigns]

http://www.etcontrol.c om/autosuggest/autosuggest.php

I am trying to add a drop down to filter the results. Is there a way to do that? Or just point me in the right direction. Thanks!!!

<?php include('xxxx.php');   
 
    $SQL_FROM = 'directory';        
    $searcht = $_GET['t'];
    $SQL_WHERE = 'City';
 
    if ($searcht=='Zip')
    $SQL_WHERE = 'Zip';
 
    if ($searcht=='Manuf')
    $SQL_WHERE = 'Manuf';
 
?>
<?php
            $searchq        =    strip_tags($_GET['q']);        
            $getRecord_sql    =     'SELECT * FROM '.$SQL_FROM.' WHERE '.$SQL_WHERE.' LIKE "'.$searchq.'%"';
            $getRecord        =      mysql_query($getRecord_sql);
            if(strlen($searchq)>0){
 
            echo '<ul>';
            while ($row = mysql_fetch_array($getRecord)) {?>
 
    <img src="/images/icon.png" border="0" />
    <?php echo $row['City'];?> 
    <?php echo $row['Zip'];?> <img src="/autosuggest/lib/white_arrow.png" width="12" height="12" /> 
    <?php echo $row['CoName'];?> <img src="/autosuggest/lib/phone.png" width="12" height="12" />
    <?php echo $row['Phone'];?> 
    <?php echo $row['DLR']? '<img src="dealer.gif" align="middle">' : '';?>
    <?php echo $row['RNT']? '<img src="rental.gif" align="middle">' : '';?>
    <?php echo $row['MFG']? '<img src="manuf.gif" align="middle">' : '';?>
    <?php echo $row['SVC']? '<img src="service.gif" align="middle">' : '';?>
    <?php echo $row['SUP']? '<img src="supplier.gif" align="middle">' : '';?>
    <?php echo $row['PK']? '<img src="park.gif" align="middle">' : '';?>
    <?php echo $row['NDR']? '<img src="national.gif" align="middle">' : '';?><br /></a><?php } echo '</ul>';
        ?>
<?php } ?>

This code is from Woork Blogspot

[acoder]

Where would you want the drop down? What options would you have in the drop down?

[mfdesigns]

Thanks for the response! Researching online for a solution I come to a conclusion to use a onChange function (JS) within the option value that will be called. My hang up is how to start it. Basically, the AutoSuggest filters Cities from the database based onKeypress function and shows results ... what I am trying to do is filter the results only to show RV Service, RV Parks, and etc. ... each CITY line item in the database have option values 'SVC' for RV Service, or 'PK' for RV Parks. So when AUSTIN is typed in ... it will show every type of service in that City, but I would like to have a drop down to filter just RV Service for that CITY? Sorry I'm not a programmer so I trying to explain it the best I can. Any help is appreciated! As far as, the location of the additional code ... I really don't know. I assume it would be placed with the form entry (autosuggest.ph p), or the PHP page (search.php) that initiates the MySQL searches (the code I cut/pasted in my last post).

Thanks!

www.etcontrol.c om/search_page.php

[acoder]

Use checkboxes for the services. If the checkbox for a particular service is checked, display that entry.