$sql = "select eo.encoding_order_id, eo.entry_date, ou.f_name, ou.l_name, eo.order_status , group_concat(DISTINCT cm.name ORDER BY cm.name SEPARATOR ', ') as dms_list FROM encoding_order eo LEFT JOIN customer_master cm ON cm.customer_id IN (eo.dms_list) LEFT JOIN orchadmin_users ou ON ou.id = eo.orchadmin_user_id WHERE eo.type = 'clip' GROUP BY eo.encoding_order_id ORDER BY eo.entry_date LIMIT 5 "; if (!$delivery_order_result = mysql_query($sql)) showerror(); if(mysql_num_rows($delivery_order_result)) { ?>
| ID | Entry Date | Entered By | Status | DMS List |
|---|---|---|---|---|
| =$delivery_order_row['encoding_order_id']?> | =format_date($delivery_order_row['entry_date'])?> | =$delivery_order_row['f_name']?> =$delivery_order_row['l_name']?> | =$delivery_order_row['order_status']?> | =$delivery_order_row['dms_list']?> |