File manager - Edit - /home/autoph/public_html/connect/home/PRF_LoadActiveVendorslBasedOnSelectedCompany.php
Back
<?php include_once 'core/init.php'; $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $poByCompany = mysql_escape_string($_POST['poByCompany']); $getCompanyList = mysql_query("SELECT prf_suppliers.`sup_code`,prf_suppliers.`sup_name`,prf_suppliers.`id`, prf_request_detl.`comp_id`,prf_request_detl.`award_to_vendor_id`,prf_request_detl.`header_ref_code`,prf_request_detl.`comp_id`,prf_request_detl.`award_to_vendor_id`,prf_request_detl.`approved_proposal_code` FROM prf_request_detl JOIN prf_suppliers ON prf_request_detl.`award_to_vendor_id` = prf_suppliers.`id` WHERE prf_request_detl.`comp_id`='$poByCompany' AND prf_request_detl.`award_to_vendor_id` = prf_suppliers.`id` AND prf_request_detl.`po_code`='' GROUP BY prf_request_detl.`award_to_vendor_id` ORDER BY prf_suppliers.`sup_name` ASC "); echo "<option value='0'>-- Select Vendor --</option>"; while($srow=mysql_fetch_array($getCompanyList)){ echo "<option value='".$srow['award_to_vendor_id']."'>".strtoupper($srow['sup_name']."-".$srow['sup_code'])."</option>"; } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings