load_lang(); $db = new Database(); $stmt = $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 = ? AND notes.coll_id = ? ODER BY notes.date_note DESC",array($_REQUEST['id'],$_REQUEST['collId'])); //$db->show(); $notesList = ''; if ($stmt->rowCount()< 1) { $notesList .= 'no notes'; } else { while ($line = $stmt->fetchObject()) { $line->note_text = str_replace("\n", "
", $line->note_text); $notesList .= '

' . functions::xssafe($line->firstname) . ' ' . functions::xssafe($line->lastname) . ' le ' . functions::xssafe($line->date_note) . '

' . functions::xssafe($line->note_text) . '

'; } } ?>