load_lang(); $db = new dbquery(); $db->connect(); $db->query( "SELECT contacts_v2.society as society, contact_addresses.lastname as lastname, contact_addresses.firstname as firstname, contact_addresses.contact_purpose_id as contact_purpose_id, contact_purposes.label as label, 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_num as address_num, contact_addresses.address_street as address_street, contact_addresses.address_town as address_town, contact_addresses.address_postal_code as address_postal_code, contact_addresses.address_country as address_country, contact_addresses.address_complement as address_complement, contact_addresses.website as website, contact_addresses.departement as departement FROM " .APPS_CONTACTS_ADDRESSES.",".APPS_CONTACTS_V2.",".APPS_CONTACTS_PURPOSES." WHERE contact_addresses.id = ".$_REQUEST['id']. " and contact_addresses.contact_purpose_id=contact_purposes.id "); //$db->show(); $db2 = new dbquery(); $db2->connect(); $db2->query( "SELECT contact_purposes.id as id, contact_purposes.label as label from contact_purposes"); $notesList = ''; if ($db->nb_result() < 1) { $notesList = 'no contact or error query'; } else { while($line = $db->fetch_object()) { ?>

 Infos