"; $title = $note['title']; $date_posted = explode("-", $note['date_posted']); $year_posted = $date_posted[0]; $month_posted = $date_posted[1]; $day_posted = $date_posted[2]; echo "

$year_posted/$month_posted/$day_posted/$title

"; echo $note['text']; echo ""; } } else { if (isset($_GET['page']) && is_numeric($_GET['page'])) { $page = (int) $_GET['page']; } else { $page = 1; } if ($page < 1) { $page = 1; } else if ($page > $total_number_of_pages) { $page = $total_number_of_pages; } $page_offset = ($page - 1) * $notes_per_page; $notes = mysql_query("SELECT title, date_posted, text, url FROM notes ORDER BY date_posted DESC LIMIT $page_offset, $notes_per_page"); while($note = mysql_fetch_array($notes)) { echo "
"; $title = $note['title']; $date_posted = explode("-", $note['date_posted']); $year_posted = $date_posted[0]; $month_posted = $date_posted[1]; $day_posted = $date_posted[2]; $url = $note['url']; echo "

$year_posted/$month_posted/$day_posted/$title

"; echo $note['text']; echo "
"; } echo "

"; if($page != 1){ if(!$page == 2 && $total_number_of_pages == 2) echo "first / "; $previous_page = $page - 1; echo "prev"; } if($page < $total_number_of_pages) { $forward_page = $page + 1; echo "next"; } if($page != $total_number_of_pages && (!$page == 1 && $total_number_of_pages == 2)){ echo " / last"; } echo "

"; } ?>