return_result("SELECT sd.id,sd.name FROM source_dealer sd INNER JOIN source_company_dealer scd ON sd.id=scd.dealer_id WHERE scd.company_id = '$company_id' and type = 1 and sd.status = 1 and scd.status = 1 GROUP BY sd.id ORDER BY sd.name ASC"); //print_r($clients); foreach($dealer as $data){ $dealer_list = $dealer_list."".$data['name'].""; } echo $dealer_list; } ?>