load_lang();
$db = new dbquery();
$db->connect();
$db->query(
"SELECT
contacts_v2.society as society,
contacts_v2.contact_id as contact_id,
contacts_v2.is_corporate_person as is_corporate_person,
contacts_v2.firstname as firstname,
contacts_v2.lastname as lastname
FROM " .APPS_CONTACTS_V2. "
ORDER BY contacts_v2.lastname, contacts_v2.society
");
//$db->show();
$i=0;
$notesList = '';
if ($db->nb_result() < 1) {
$notesList .= 'no contacts';
} else {
while ($line = $db->fetch_object()) {
if(($line->user_id == $_SESSION['user']['UserId']) || ($line->user_id == "")) {
if($line->firstname != '' or $line->lastname != '') {
$notesList .= '
';
} else { var_dump($line->user_id);
$notesList .= '
';
}
}
}
}
?>