query("job_cards", "SELECT * FROM job_cards WHERE `status` = 1"); echo ""; $sql = "SELECT * FROM order_trans WHERE 1 $jc_number $date_time $user_id $po_number ORDER BY record_id DESC LIMIT 100"; $res = $db->query("order_trans", $sql); if ($res->num_rows > 0) { $index = 0; while ($data = $res->fetch_assoc()) { // build users_select $users_res = $db->query('users', "SELECT * FROM users WHERE record_id='{$data['user_id']}'"); if ($users_res->num_rows > 0) { while ($users_data = $users_res->fetch_assoc()) { $select_users .= "{$users_data['username']}"; } } else { $select_users .= ""; } // build users_select $users_res = $db->query('users', "SELECT * FROM users WHERE user_type='WAREHOUSE'"); if ($users_res->num_rows > 0) { while ($users_data = $users_res->fetch_assoc()) { $select_users .= "{$users_data['username']}"; } } else { $select_users .= "No Data Found"; } // build purchase_orders $orders_res = $db->query('orders', "SELECT * FROM orders WHERE record_id='{$data['order_id']}'"); if ($orders_res->num_rows > 0) { while ($orders_data = $orders_res->fetch_assoc()) { $select_orders .= "{$orders_data['po_number']}"; } } else { $select_orders .= ""; } // build purchase_orders $orders_res = $db->query('orders', "SELECT * FROM orders WHERE `status`=0"); if ($orders_res->num_rows > 0) { while ($orders_data = $orders_res->fetch_assoc()) { $select_orders .= ""; $select_orders .= "{$orders_data['po_number']}"; } } else { $select_orders = "No Data Found"; } $html .= " " . $call->get_stock_name($data['stock_id']) . " $select_users $select_orders "; $select_orders = ''; $select_users = ''; $index++; } } else { $html = "No Record Found"; } echo $html;