File: /home/durgeshpandey215/www/zeeroprice.skilladders.com/categories.php
<?
$catselected = (isset($catselected))? $catselected : "";
$catname = (isset($catname))? $catname : 'catid';
$isclass = (isset($isclass))? $isclass : '';
$sqlcats = "select * from categories where istatus = ? ";
$paramcats = array(1);
$rowscats = $db->rawQuery($sqlcats,$paramcats);
?>
<select name="<?=$catname;?>" id="<?=$catname;?>" class="<?=$isclass;?>" required>
<option value="">Select Category</option>
<?
if(count($rowscats)){
foreach($rowscats as $rowcats){
?><option value="<?=$rowcats['catid'];?>" <?if($rowcats['catid']== $catselected){ echo "selected='selected'";}?>><?=$rowcats['catname'];?></option><?
}
}
?>
</select>