load_lang(); $db = new dbquery(); $db->connect(); $db->query( "SELECT u.lastname as lastname, u.firstname as firstname, notes.note_text, " . "notes.date_note as date_note, notes.id as notes_id FROM " . NOTES_TABLE . " notes, " . $_SESSION['tablename']['users'] ." u where notes.user_id = u.user_id and " . "notes.identifier = " . $_REQUEST['id'] . " and notes.coll_id ='" . $_REQUEST['collId'] . "' order by notes.date_note desc" ); //$db->show(); $notesList = ''; if ($db->nb_result() < 1) { $notesList .= 'aucune note'; } else { while ($line = $db->fetch_object()) { $line->note_text = str_replace("\n", "
", $line->note_text); $notesList .= '

' . $line->firstname . ' ' . $line->lastname . ' le ' . $line->date_note . '

' . $line->note_text . '

'; } } ?>