';
} else {
$i4 = 0; $lab_order_list = "";
while ($i4 < $num_rows_lab1) {
$rs_lab1 = $result_lab1 ? mysqli_fetch_array($result_lab1) : [];
$lab_order_list = ($lab_order_list == "") ? "'" . $rs_lab1["lab_order_number"] . "'" : $lab_order_list . ",'" . $rs_lab1["lab_order_number"] . "'";
$i4++;
}
if ($lab_order_list == "") $lab_order_list = "0";
// Added GROUP BY to prevent duplicates, ORDER BY i.lab_items_name ASC for alphabetical sorting
$sqlLab2 = "select l.*,i.lab_items_name,i.lab_items_unit,i.lab_items_code,i.lab_items_normal_value,e.staff,l.lab_order_number,j.lab_items_sub_group_name,h.order_date from lab_order l left outer join lab_entry_log e on e.lab_order_number=l.lab_order_number left outer join lab_items i on i.lab_items_code=l.lab_items_code left outer join lab_order_image k on k.lab_order_number=l.lab_order_number left outer join lab_items_sub_group j on j.lab_items_sub_group_code = l.lab_items_sub_group_code LEFT OUTER JOIN lab_head h ON h.lab_order_number = l.lab_order_number where l.lab_order_number in ($lab_order_list) and l.lab_order_result <>'' and i.lab_items_code not in ('332','657','1590','1592','1594','1596','1602','1604','1606','1608') GROUP BY l.lab_order_number, i.lab_items_code order by i.lab_items_name ASC";
mysqli_query($conn1, "SET SESSION sql_mode=''");
$result_lab2 = mysqli_query($conn1, $sqlLab2);
$num_rows_lab2 = $result_lab2 ? mysqli_num_rows($result_lab2) : 0;
if ($num_rows_lab2 == 0) {
echo '
 . ')
';
} ?>