File manager - Edit - /home/autoph/public_html/connectv1/app/company_dealer/update_dealer_designation.php
Back
<?php include_once("../../cfg/db.php"); $id = $db->escape(trim($_POST['id'])); //$id = $_POST['id'][0]; $json_arr['rows'] = array(); // $query_dealer = "SELECT scd.dealer_id, sd.name AS dealer_name, sd.code AS dealer_code // FROM source_company_dealer scd // INNER JOIN source_dealer sd ON scd.dealer_id=sd.id // WHERE company_id = '$id' AND scd.status = 1"; $query_dealer = "SELECT sd.id,sd.code,sd.name FROM source_dealer sd INNER JOIN source_company_dealer scd ON sd.id=scd.dealer_id WHERE 1 AND scd.company_id = '$id' AND type = 1 AND sd.status = 1 and scd.status = 1 GROUP BY sd.id ORDER BY sd.code ASC"; //echo $query_dealer; return; $query_dealer_info = $db->sql_query($query_dealer); while($row = $query_dealer_info->fetch_assoc()) { echo '<option value="'.$row['id'].'"><i class="fa fa-trash"></i>'.$row["code"].' - '.$row["name"].'</option>'; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings