0) { $i = 0; while ($echallan_request = mysqli_fetch_array($result_echallan_request)) { $sql = "select * from orders where order_id = " . $echallan_request['order_id'] . ""; $match_quality = mysqli_query($link, $sql); $row_quality_data = $match_quality->fetch_assoc(); $sql11 = "select * from quality where quality_id = " . $row_quality_data['quality_id'] . ""; $match_quality2 = mysqli_query($link, $sql11); $row_quality_data2 = $match_quality2->fetch_assoc(); $sql2 = "select * from buyer where buyer_id = " . $row_quality_data['buyer_id'] . ""; $match_buyer = mysqli_query($link, $sql2); $row_buyer_data = $match_buyer->fetch_assoc(); $sql3 = "select * from seller where seller_id = " . $row_quality_data['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 ""; } } else { echo ""; echo ""; echo ""; } ?>

No	Echallan ID	Seller Name	Buyer Name	Quality Name	Quality Image	Price	Date	Quantity	Unit	Action
" . $i . "	" . $echallan_request['echallan_id'] . "	" . $row_seller_data['seller_name'] . "	" . $row_buyer_data['buyer_name'] . "	" . $row_quality_data2['quality_name'] . "		" . $echallan_request['echallan_price'] . "	" . $echallan_request['echallan_date'] . "	" . $echallan_request['quantity_num'] . "	" . $echallan_request['quantity_unit'] . "	" . $echallan_request['payment_status'] . "	" . $echallan_request['echallan_status'] . "	Genrate Brokerage Bill
echallan is Not Found