<? require_once "application_top.php"; 
$catid = (isset($_REQUEST['catid']))? $_REQUEST['catid'] : "";
$catselected = (isset($catselected))? $catselected : "";
$subcatselected = (isset($subcatselected))? $subcatselected : "";//optional
$subcatname = (isset($subcatname))? $subcatname : 'subcatid';
$isclass = (isset($isclass))? $isclass : 'w3-input';
$rowssubcats = array();

if($catid || $catselected){
		$paramsubcats = array();
		$sqlsubcats = "select * from subcategories where istatus = ? ";
		$paramsubcats[] = 1;
		if($catid){
		$sqlsubcats .= " and catid=? ";
		$paramsubcats[] = $catid;
		}else if($catselected){
		$sqlsubcats .= " and catid=? ";
		$paramsubcats[] = $catselected;
		}
		$sqlsubcats;
		$rowssubcats = $db->rawQuery($sqlsubcats,$paramsubcats);
		//print_r($rowssubcats);
}
?>
<select name="<?=$subcatname;?>" id="<?=$subcatname;?>" class="<?=$isclass;?>" required>
	<option value="">Select Subcategory</option>
	<?
	if(count($rowssubcats)){
		foreach($rowssubcats as $rowsubcats){
		?><option value="<?=$rowsubcats['subcatid'];?>" <?if($rowsubcats['subcatid']== $subcatselected){ echo "selected='selected'";}?>><?=$rowsubcats['subcatname'];?></option><?
		}
	}
	?>
</select>