";
$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 "
";
}
?>