public function latest()
{
$contact = new contact();
$sql = "SELECT * FROM {$this->table_notes} ORDER BY note_create_time DESC LIMIT 10";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$notetype = $row['note_type'];
if ($notetype == "upload") {
echo '
<a href="contacts.php?q=view&id=' . $row['contact_id'] . '">
<b><u>' . $contact->getbyname($row['contact_id']) . '</u></b> <u>on ' . date("m/d/Y", $row['note_create_time']) . '</u><br />
</a>
';
echo '<b>[File Uploaded]</b>';
echo '<br /><br />';
//echo $row['note_text'] . '<br /><br />';
} else {
echo '
<a href="contacts.php?q=view&id=' . $row['contact_id'] . '">
<b><u>' . $contact->getbyname($row['contact_id']) . '</u></b> <u>on ' . date("m/d/Y", $row['note_create_time']) . '</u><br />
</a>
';
echo $row['note_text'] . '<br /><br />';
}
}
}
