Как реализовать отбор объявлений по типу? - AdsManager

$database->setQuery( "SELECT f.fieldtitle,f.fieldid,f.fieldvalue FROM #__adsmanager_field_values AS f WHERE f.fieldid = 8 ORDER BY f.fieldvalueid");
	$searchs222 = $database->loadObjectList();

  <?php echo ADSMANAGER_ORDER_BY_TEXT; ?>
              <?php if (isset($searchs)) { ?>
              <select name="order2" onchange="jumpmenu('parent',this)">
                    <option value="<?php echo sefRelToAbs($url."&amp;expand=".$expand."&amp;order=0&amp;Itemid=".$itemid);?>" selected="selected" <?php if ($order == "0") { echo "selected='selected'"; } ?>><?php echo ADSMANAGER_DATE; ?></option>
                    <?php /*<option value="<?php echo sefRelToAbs($url."&amp;order=-1");?>" <?php if ($order == "-1") { echo "selected='selected'"; } ?>><?php echo ADSMANAGER_ORDER_HITS; ?></option> */ ?>
                    <?php foreach($searchs as $s)
				   {
	               ?>
                    <option value="<?php echo sefRelToAbs($url."&amp;expand=".$expand."&amp;order=".$s->fieldid."&amp;Itemid=".$itemid);?>" <?php if ($order == $s->fieldid) { echo "selected='selected'"; } ?>><?php echo adsmanager_html::getLangDefinition($s->title); ?></option>
                    <?php
				   }
				 ?>
              </select>
              <?php } ?>
 

   			  <?php echo ADSMANAGER_ORDER_BY_TYPE; ?>   
              <?php if (isset($searchs222)) { ?>
              <select name="my_list" onchange="jumpmenu('parent',this)">
                    <option value="<?php echo sefRelToAbs($url."&amp;expand=".$expand."&amp;page=show_all&amp;ad_kindof=0&amp;Itemid=".$itemid);?>" selected="selected" <?php if ($ad_kindof == $s222->fieldvalue) { echo "selected='selected'"; } ?>><?php echo ADSMANAGER_SELECT_TYPE; ?></option>
              <?php foreach($searchs222 as $s222)
				{
				?>
<option value="<?php echo sefRelToAbs($url."&amp;expand=".$expand."&amp;page=show_all&amp;ad_kindof=".$s222->fieldvalue."&amp;Itemid=".$itemid);?>" <?php if ($ad_kindof == $s222->fieldvalue) { echo "selected='selected'"; } ?>><?php echo adsmanager_html::getLangDefinition($s222->fieldtitle); ?></option>
                <?php
				}
   				?>
              </select>
              <?php } ?>

<option value="" selected="selected" ></option>

  			  <?php echo ADSMANAGER_ORDER_BY_TYPE; ?>   
              <?php if (isset($searchs222)) { ?>
              <select name="my_list" onchange="jumpmenu('parent',this)">
                    <option value="<?php echo sefRelToAbs($url."&amp;expand=".$expand."&amp;page=show_all&amp;ad_kindof=0&amp;Itemid=".$itemid);?>" selected="selected" <?php if ($ad_kindof == $s222->fieldvalue) { echo "selected='selected'"; } ?>><?php echo ADSMANAGER_SELECT_TYPE; ?></option>
              <?php foreach($searchs222 as $s222)
				{
				?>
<option value="<?php echo sefRelToAbs($url."&amp;expand=".$expand."&amp;page=show_all&amp;ad_kindof=".$s222->fieldvalue."&amp;Itemid=".$itemid);?>" <?php if ($ad_kindof == $s222->fieldvalue) { echo "selected='selected'"; } ?>><?php echo adsmanager_html::getLangDefinition($s222->fieldtitle); ?></option>
                <?php
				}
   				?>
              </select>
              <?php } ?>

//nanana
	if ($ad_kindof==0)
	{
	$database->setQuery( "SELECT f.fieldtitle,f.fieldid,f.fieldvalue FROM #__adsmanager_field_values AS f WHERE f.fieldid = 8 ORDER BY f.fieldvalueid");

	$searchs222 = $database->loadObjectList();
	}
		else if ($ad_kindof != 0)
	{
	$database->setQuery( "SELECT f.fieldtitle,f.fieldid,f.fieldvalue FROM #__adsmanager_field_values AS f WHERE f.fieldid = 8 ORDER BY f.fieldvalueid");

	$searchs222 = $database->loadObjectList();
	}