0) { while ($enquiry_request = mysqli_fetch_array($result_enquiry_request)) { $sql = "select * from quality where quality_id = " . $enquiry_request['quality_id'] . ""; $match_quality = mysqli_query($link, $sql); $row_quality_data = $match_quality->fetch_assoc(); $sql2 = "select * from buyer where buyer_id = " . $enquiry_request['buyer_id'] . ""; $match_buyer = mysqli_query($link, $sql2); $row_buyer_data = $match_buyer->fetch_assoc(); // $sql3 = "select * from seller where seller_id = " . $enquiry_request['seller_id'] . ""; // $match_seller = mysqli_query($link, $sql3); // $row_seller_data = $match_seller->fetch_assoc(); echo ""; echo ""; echo ""; ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // if ($enquiry_request['enquiry_img'] != null) { // echo ""; // } else { // echo ""; // } echo ' '; echo ''; echo ""; // $i++; } } else { echo ""; echo ""; echo ""; } ?>

No	Enquiry ID	Buyer Name	Quality Name	Provisional Price	Negotiation 1 price	Negotiation 1 status	Negotiation 2 price	Negotiation 2 status	Negotiation 3 price	Negotiation 3 status	Negotiation 4 price	Negotiation 4 status	Final Negotiation price	Quantity Number	Quantity Unit	Expected Delivery Days From Buyer	Expected Delivery Days From Seller	Expected Payment Days From Buyer	Expected Payment Days From Seller	Final Delivery Days	Final Payment Days	Fabric Required Width	Upload Date	Status	View	Action
". $i++ ; "	" . $enquiry_request['enquiry_id'] . "	" . $row_buyer_data['buyer_name'] . "	" . $row_quality_data['quality_name'] . "	" . $enquiry_request['provisional_price_per_meter'] . "	" . $enquiry_request['negotiation_1_price'] . "	" . $enquiry_request['negotiation_1_status'] . "	" . $enquiry_request['negotiation_2_price'] . "	" . $enquiry_request['negotiation_2_status'] . "	" . $enquiry_request['negotiation_3_price'] . "	" . $enquiry_request['negotiation_3_status'] . "	" . $enquiry_request['negotiation_4_price'] . "	" . $enquiry_request['negotiation_4_status'] . "	" . $enquiry_request['final_negotiation_price'] . "	" . $enquiry_request['quantity_num'] . "	" . $enquiry_request['quantity_unit'] . "	" . $enquiry_request['expected_delivery_days_from_buyer'] . "	" . $enquiry_request['expected_delivery_days_from_seller'] . "	" . $enquiry_request['expected_payment_days_from_buyer'] . "	" . $enquiry_request['expected_payment_days_from_seller'] . "	" . $enquiry_request['final_delivery_days'] . "	" . $enquiry_request['final_payment_days'] . "	" . $enquiry_request['fabric_required_width'] . "	" . $enquiry_request['enquiry_upload_date'] . "	" . $enquiry_request['enquiry_status'] . "			View Chat
Enquiry is Not Found