'; $return .= ''; $db = new dbquery(); $db->connect(); $query = "select c.contact_firstname, c.contact_lastname, c.firstname, c.lastname, c.society, c.address_num, c.address_street, c.address_complement, c.address_town, c.address_postal_code, c.address_country "; $query .= "from view_contacts c, contacts_res cres "; $query .= "where cres.coll_id = 'letterbox_coll' AND cres.res_id = ".$_REQUEST['res_id']." AND cast (c.contact_id as varchar) = cres.contact_id AND c.ca_id = cres.address_id"; $db->query($query); $fetch = ''; while ($res = $db->fetch_object()) { $return .= ''; $return .= ''; $return .= ''; } $db = new dbquery(); $db->connect(); $query = "select u.firstname, u.lastname, u.user_id "; $query .= "from users u, contacts_res cres "; $query .= "where cres.coll_id = 'letterbox_coll' AND cres.res_id = ".$_REQUEST['res_id']." AND cast (u.user_id as varchar) = cres.contact_id"; $db->query($query); $fetch = ''; while ($res = $db->fetch_object()) { $return .= ''; $return .= ''; $return .= ''; } $return .= '

'; $return .= '

'; $return .= $res->contact_lastname . ' ' . $res->contact_firstname . ' ' . $res->firstname . ' ' . $res->lastname . ' ' . $res->society . ' (contact)'; if(isset($res->address_num) && !empty($res->address_num)){ $return .= ': ' . $res->address_num; } if(isset($res->address_street) && !empty($res->address_street)){ $return .= ', ' . $res->address_street; } if(isset($res->address_complement) && !empty($res->address_complement)){ $return .= ', ' . $res->address_complement; } if(isset($res->address_postal_code) && !empty($res->address_postal_code)){ $return .= ', ' . $res->address_postal_code; } if(isset($res->address_town) && !empty($res->address_town)){ $return .= ' ' . $res->address_town; } if(isset($res->address_country) && !empty($res->address_country)){ $return .= ', ' . $res->address_country; } $return .= '

'; //$return .= '
'; $return .= '

'; $return .= '

'; $return .= $res->firstname . ' ' . $res->lastname . ' (utilisateur)'; $return .= '

'; //$return .= '
'; $return .= '

'; $return .= '
'; $return .= '