<?php

include 'config.php';

// SELECT COMMAND	
$query = "SELECT wp_wpl_addon_crm_contacts.last_name AS last_name, wp_wpl_addon_crm_contacts.first_name AS first_name, wp_wpl_properties.field_313_fr_fr AS field_313_fr_fr FROM wp_wpl_addon_crm_contacts JOIN wp_wpl_properties ON wp_wpl_addon_crm_contacts.id = wp_wpl_properties.field_3006 WHERE wp_wpl_properties.field_3006=".$_GET['id'];


$result = mysqli_query($mysqli, $query) or die("SQL Error 1: " . mysqli_error());

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
    $List[] = array(
        'lastname' => mb_convert_encoding($row['last_name'], "UTF-8", "HTML-ENTITIES"),
        'firstname' => mb_convert_encoding($row['first_name'], "UTF-8", "HTML-ENTITIES"),
    );
}

echo json_encode($List);
$result->close();
$mysqli->close();
?>