>
connect();
$db2 = new dbquery();
$db2->connect();
$couleur=0;
if(empty($_SESSION['tablechoice']))
{
$_SESSION['tablechoice'] = 'res_x';
}
if(isset($_GET['id']))
{
$s_id = $_GET['id'];
}
else
{
$s_id = "";
}
$db->query("select i.ID, i.INFO, i.DATE, i.USER_ID, u.LASTNAME, u.FIRSTNAME from ".$_SESSION['tablename']['notes']." i
inner join ".$_SESSION['tablename']['users']." u on i.USER_ID = u.USER_ID WHERE RECORD_ID = ".$s_id." AND ((i.ACCESS_SERVICES = 'all' AND i.ACCESS_USERS = 'all') OR (i.ACCESS_USERS = 'not' AND i.ACCESS_SERVICES LIKE '%".$_SESSION['user']['department']."%') OR (i.ACCESS_SERVICES = 'not' AND i.ACCESS_USERS LIKE '%".$_SESSION['user']['UserId']."%') OR (i.USER_ID ='".$_SESSION['user']['UserId']."')) ORDER BY DATE desc");
//$db->show();
//print_r($_SESSION['user']['[UserId']);
?>