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 />'; } } }