load_lang(); $db = new Database(); $stmt = $db->query( "SELECT contacts_v2.lastname as lastname, contacts_v2.firstname as firstname, contacts_v2.contact_id as contact_id, contacts_v2.society as society, contacts_v2.function as function, contacts_v2.other_data as other_data, contacts_v2.is_corporate_person as is_corporate_person, contacts_v2.user_id as user_id, contacts_v2.title as title, contacts_v2.enabled as enabled, 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_complement as address_complement, contact_addresses.address_town as address_town, contact_addresses.address_postal_code as address_postal_code, contact_addresses.address_country as address_country FROM " .APPS_CONTACTS_V2. " INNER JOIN ".APPS_CONTACTS_ADDRESSES." ON contacts_v2.contact_id = contact_addresses.contact_id WHERE contacts_v2.contact_id = ?",array($_REQUEST['contact_id'])); //$db->show(); $notesList = ''; $_SESSION['contact_id'] = $_REQUEST['contact_id']; if ($stmt->rowCount() < 1) { $notesList = 'No contact or error query'; } else { while($line = $stmt->fetchObject()) { ?>

Infos

lastname != "") { ?>

firstname != "") { ?>

society != "") { ?>

phone != "") { ?>

email != "") { ?>

<?php functions::xecho($line->address_num . ' '
																						. $line->address_street . ' '
																						.$line->address_complement . ' '
																						. $line->address_postal_code . ' '
																						. $line->address_town . ' '
																						. $line->address_country); ?>

other_data != "") { ?>

                                        <?php functions::xecho($line->other_data); ?>