<?				
	$get_clients = "
	SELECT 	
		clients.id,
		clients.company_name, 	
		clients_locations.address, 
		clients_locations.suburb, 
		clients_locations.state, 
		clients_locations.post_code, 
		clients_locations.id AS location_id
	FROM clients
		LEFT JOIN clients_locations ON (clients.primary_location_id  = clients_locations.id)	
	WHERE clients.company_name LIKE '%".$term."%'
	ORDER BY clients.company_name ASC
	";
	$results = $database->getAll($get_clients);							
	
	$company_name = array();
	
	if(count($results) > 0)
		foreach($results AS $result)
			$company_name[] = array(
				"value" => $result['company_name'],
				"id" => $result['id'],
				"location_id" => $result['location_id'],
				"address" => $result['address'], 
				"suburb" => $result['suburb'], 
				"state" => $result['state'], 
				"post_code" => $result['post_code']
				);
		
	$json = json_encode($company_name);
		
	echo $json;		
?>