Demo (Reference) Project
https://mobile.aeroitsolution.com/index.php
Username : demo
Password : Demo
Code :
<select class="form-control paymentstatus" value="admin_status"> <option value="0&mid=<?php echo $data['id'];?>" <?php if($data['status'] == "0"){ ?> selected <?php } ?> >Pending</option> <option value="1&mid=<?php echo $data['id'];?>" <?php if($data['status'] == "1"){ ?> selected <?php } ?>>Accept</option> </select>
<td> <?php if($data['kemployee']==""){ echo "Null"; }else{ $updateemploeey = $conn->query("SELECT * FROM enquiry_form LEFT JOIN department_category ON department_category.cat_id=enquiry_form.department_id where enquiry_form.id = '".$data['kemployee']."'")->fetch_assoc(); ?> <span class="text-warning"><?=$updateemploeey['cat_name']?></span> <br> <span class="text-success"><?=$updateemploeey['name']?></span> <?php } ?> </td>