0) { $i = 0; while ($order_request = mysqli_fetch_array($result_orders_request)) { $sql = "select * from quality where quality_id = " . $order_request['quality_id'] . ""; $match_quality = mysqli_query($link, $sql); $row_quality_data = $match_quality->fetch_assoc(); $sql2 = "select * from buyer where buyer_id = " . $order_request['buyer_id'] . ""; $match_buyer = mysqli_query($link, $sql2); $row_buyer_data = $match_buyer->fetch_assoc(); $sql3 = "select * from seller where seller_id = " . $order_request['seller_id'] . ""; $match_seller = mysqli_query($link, $sql3); $row_seller_data = $match_seller->fetch_assoc(); $i++; echo ""; echo ""; echo ""; // echo ""; // echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; // echo ""; if ($order_request['payment_status'] == 'Pending') { echo ""; } else if ($order_request['payment_status'] == 'Completed') { echo ""; } // echo ""; if ($order_request['order_status'] == 'Processing') { echo ""; } else if ($order_request['order_status'] == 'Delivered') { echo ""; } else if ($order_request['order_status'] == 'Confirmed') { echo ""; } echo ''; echo ""; } } else { echo ""; echo ""; echo ""; } ?>

No	Order ID	Buyer Name	Seller Name	Quality Name	Quality Image	Quantity	Price	Order Value	Order Date	Delivery Date	Delivery Days	Payment Date	Payment Days	Payment Status	Order Status	Action
" . $i . "	" . $order_request['order_id'] . "	" . $order_request['enquiry_id'] . "	" . $order_request['proposal_id'] . "	" . $row_buyer_data['buyer_name'] . "	" . $row_seller_data['seller_name'] . "	" . $row_quality_data['quality_name'] . "		" . $order_request['quantity_num'] . "	Rs.". $order_request['final_price'] . "	" . $order_request['order_value'] . "	" . $order_request['order_date'] . "	" . $order_request['delivery_date'] . "	" . $order_request['delivery_days'] . "	" . $order_request['payment_date'] . "	" . $order_request['payment_days'] . "	" . $order_request['payment_status'] . "	" . $order_request['order_status'] . "	" . $order_request['payment_status'] . "	" . $order_request['payment_status'] . "	" . $order_request['order_status'] . "	" . $order_request['order_status'] . "	" . $order_request['order_status'] . "	" . $order_request['order_status'] . "	View E-challan
Order is Not Found