load_lang();
$db = new dbquery();
$db->connect();
$db->query(
"SELECT
contact_addresses.lastname as lastname,
contact_addresses.firstname as firstname,
contact_addresses.contact_id as contact_id,
contact_addresses.is_private as is_private,
contact_addresses.email as email,
contact_addresses.phone as phone,
contact_addresses.address_postal_code as address_postal_code,
contact_addresses.id as id,
contact_addresses.address_num as address_num,
contact_addresses.address_street as address_street,
contact_addresses.address_complement as address_complement,
contact_addresses.address_town as address_town,
contact_addresses.departement as address_departement,
contact_addresses.address_country as address_country
FROM " .APPS_CONTACTS_ADDRESSES. "
WHERE contact_addresses.contact_id = (select contact_id from ".APPS_CONTACTS_V2." where contact_id = " .$_REQUEST['contact_id']. "
)");
//$db->show();
$i=0;
$notesList = '';
if ($db->nb_result() < 1) {
$notesList .= 'no contacts';
} else { $notesList .= '';
while ($line = $db->fetch_object()) { $society= $line->society;
if(($line->user_id == $_SESSION['user']['UserId']) || ($line->user_id == "")) {
$notesList .= '
';
}
}
$noteList .= '
';
}
?>