<?php 
include("../connection.php");
include("../user.php");
$item_from_division=$_REQUEST['from_division'];
?>
<div class="row form-group">
			<div class="col col-md-3"><label for="text-input" class=" form-control-label">Category</label><span style="color:red;">*</span></div>
			<div class="col-12 col-md-9">
				<select name="item_search" id="item_search" placeholder="select Item" class="form-control" autocomplete="off" required>
					<option value="" selected disabled>Select Item</option>
					 <?php  $ctg=mysqli_query($con,"SELECT * FROM item_master where status='0' and division='$item_from_division' GROUP BY category, category_description order by id");
						while($ctgr=mysqli_fetch_array($ctg)) { ?>
							<option value="<?php echo $ctgr['category']." / ".$ctgr['category_description']; ?>"><?php echo strtoupper($ctgr['category']." - ".$ctgr['category_description']); ?></option>
						 <?php  } ?>
				</select>
			</div>
		</div>