<tbody> <?php $store_key = $_SESSION['mystoreid']; $result = mysqli_query($con, "select r.*, m.medicine_name from `return_stock` as r join `medicine` as m on (r.medicine_id = m.medicine_id and r.store_key = '{$store_key}' and m.store_key = '{$store_key}' and r.status <> 0)"); $index = 0; $records = array(); $medicines = array(); $users = array(); $distributors = array(); while ($row = mysqli_fetch_array($result)) { $records[] = $row; $medicines[] = $row['medicine_id']; $users[] = $row['returned_by']; $distributors[] = $row['distributor_id']; } $users_list = DhsHelper::getUsersList($users); $medicines_list = DhsHelper::getMedicinesList($medicines); $distributor_list = DhsHelper::getDistributorsList($distributors); foreach ($records as $record) { ?> <tr> <td><?php echo ++$index; ?> </td> <td><?php echo isset($medicines_list[$record['medicine_id']]) ? $medicines_list[$record['medicine_id']] : 'N/A'; ?> </td> <td><?php echo $record['quantity'];