code help - pagination


Posted on 16th Feb 2014 01:33 pm by admin

Hi all, I have this code, basically a user logs into my site and they get this page.

The problem I have is that the pagination isn't working, and I can figure out why. I dont get any errors.

Can you help please. If you need any more info, just shout. Ta muchly

Code: <?php
include("includes/dbconnect120-gem.php");
include("includes/db_auth_hp.php");
include("includes/functions.php");
$username = $result['username'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/templ8t.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="css/layout.css" rel="stylesheet" type="text/css" />
<link href="css/text.css" rel="stylesheet" type="text/css" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Untitled Document</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" -->
<script language="javascript" type="text/javascript">
<!--
function showhide(id) {
if(document.getElementById(id).style.display == 'none') {
document.getElementById(id).style.display = 'block';
} else {
document.getElementById(id).style.display = 'none';
}
}
-->
</script
<!-- InstanceEndEditable -->
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
.H2 {
font-size: x-large;
font-family: Arial, Helvetica, sans-serif;
background-color: #FFFF00;
}
.link {color: #FFFF33}
-->
</style>


</head>
<body>
<div class="wrapper">
<div class="header">
</div>
<div class="body">
<!-- InstanceBeginEditable name="bodytext" -->
Hello, <?php echo ucwords($username); ?> you are now logged in.

<?php

// find out how many rows are in the table
$sql = "SELECT COUNT(*) FROM articles";
$result = mysql_query($sql) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrows = $r[0];

// number of rows to show per page
$rowsperpage = 1;
// find out total pages
$totalpages = ceil($numrows / $rowsperpage);

// get the current page or set a default
if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
// cast var as int
$currentpage = (int) $_GET['currentpage'];
} else {
// default page num
$currentpage = 1;
} // end if

// if current page is greater than total pages...
if ($currentpage > $totalpages) {
// set current page to last page
$currentpage = $totalpages;
} // end if
// if current page is less than first page...
if ($currentpage < 1) {
// set current page to first page
$currentpage = 1;
} // end if

// the offset of the list, based on current page
$offset = ($currentpage - 1) * $rowsperpage;

//Gets news.
$sql = "SELECT * FROM articles ORDER BY ID DESC";
$result = mysql_query($sql);
//Displays the results.
while($row = mysql_fetch_array($result)){
$news_title = nl2br($row['Title']);
$news_subtitle = nl2br($row['SubTitle']);
$news_post = nl2br($row['Article']);
$post_id = $row['ID'];

echo $news_title;?>

<?php echo $news_subtitle; ?>

<?php echo $news_post; ?>


<!-- END DISPLAY NEWS -->

<?php
$csql = "SELECT comments.tstamp, login.username, comments.post
FROM comments
LEFT JOIN login
ON comments.userid = login.userid
WHERE comments.articleid = $post_id
ORDER BY comments.postid DESC";

$cquery = mysql_query($csql);
$ccount = mysql_num_rows($cquery);
if($ccount == 0) {
$comments_number = '<a href="comment.php?post='.$post_id.'" target="_self">No Comments</a>';
} else {
$comments_number = '<a href="#coms'.$post_id.'" onclick="showhide('c'.$post_id.'');">Comments('.$ccount.')</a>';
}
?>

<p class="right"><?php echo $comments_number; ?><a name="coms<?php echo $post_id; ?>"></a>&nbsp;&nbsp;&nbsp;</p>
<div style="display:none" id="<?php echo 'c'.$post_id; ?>" >
<?php
if($ccount != 0) {

while($crow = mysql_fetch_array($cquery)) {
$ctime = $crow['tstamp'];
$cusername = ucwords($crow['username']);
$cmessage = $crow['post'];
echo "<hr />n";
echo '<p><span class="bold">'.$cusername.':</span> '.nl2br($cmessage)."n";
echo '<br /><span class="bold">Posted: </span>';
if(timeago($ctime) == '') {
echo "Just.n";
}
elseif(strlen(timeago($ctime)) < 16) {
echo str_replace('and ', '', timeago($ctime)).'ago.</p>'."n";
} else {
echo timeago($ctime).'ago.</p>'."n";
}
}

$more = 'Leave a Comment';

echo '<p class="right"><a href="comment.php?post='.$post_id.'" target="_self">'.$more.'</a></p>';
}
?>
</div>
<?php
} // end while

/****** build the pagination links ******/
// range of num links to show
$range = 4;

// if not on page 1, don't show back links
if ($currentpage > 1) {
// show << link to go back to page 1
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";
// get previous page num
$prevpage = $currentpage - 1;
// show < link to go back to 1 page
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";
} // end if

// loop to show links to range of pages around current page
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
// if it's a valid page number...
if (($x > 0) && ($x <= $totalpages)) {
// if we're on current page...
if ($x == $currentpage) {
// 'highlight' it but don't make a link
echo " [<b>$x</b>] ";
// if not current page...
} else {
// make it a link
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
} // end else
} // end if
} // end for

// if not on last page, show forward and last page links
if ($currentpage != $totalpages) {
// get next page
$nextpage = $currentpage + 1;
// echo forward link for next page
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";
// echo forward link for lastpage
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";
} // end if
/****** end build pagination links ******/
?>





<!-- InstanceEndEditable --> </div>
<div class="sidebar">
<!-- MENU -->
<BR><?php
include "includes/menujs.js";
include "includes/menucss.css";
include "includes/menu.html";
?>
</p>
<p>

<!-- InstanceBeginEditable name="sidebar" -->
<div class="sidebartitle">
Latest News</div>


<div class="sidebartext">
</div>
<div class="sidebartitle">
Coming Soon </div>
<div class="sidebartext">
</div>
<!-- InstanceEndEditable --> </p>

</div>

</div>
<div class="clear"></div>
<div class="copyright">
<div align="center" class="style1">&copy;Copyright 2010 Bradley Stoke Judo Club || Site Designed by Gem Gale || Site Hosted by <a href="http://www.wotwebsystems.com" class="link">WOT Web Systems</a></div>
</div>

</body>
<!-- InstanceEnd --></html>

Posted on 11th May, 2017
Donnataf
Absolutely NEW update of SEO/SMM software "XRumer 16.0 + XEvil 3.0":
captchas solving of Google, Facebook, Bing, Hotmail, SolveMedia, Yandex,
and more than 8400 another size-types of captchas,
with highest precision (80..100%) and highest speed (100 img per second).
You can connect XEvil 3.0 to all most popular SEO/SMM programms: XRumer, GSA SER, ZennoPoster, Srapebox, Senuke, and more than 100 of other software.

Interested? There are a lot of demo videos about XEvil in YouTube.
Good luck ;)
Posted on 18th May, 2017
SandraMub
Absolutely NEW update of SEO/SMM package "XRumer 16.0 + XEvil 3.0":
captcha solving of Google, Facebook, Bing, Hotmail, SolveMedia, Yandex,
and more than 8400 another categories of captchas,
with highest precision (80..100%) and highest speed (100 img per second).
You can connect XEvil 3.0 to all most popular SEO/SMM programms: XRumer, GSA SER, ZennoPoster, Srapebox, Senuke, and more than 100 of other software.

Interested? There are a lot of impessive videos about XEvil in YouTube.
See you later ;)
Posted on 05th Jun, 2017
SamuelDaura
CHEAP CIALIS HERE
http://imgur.com/a/V4WUj
genaric cialis|
amad tootla cancer specialist|
buy generic cialis|
cardiovascular specialist assistant|
original cialis|
Posted on 14th Jun, 2017
Robertblawl
http://www.gagprincess.com
Posted on 23rd Jun, 2017
Robertblawl
http://www.gagprincess.com
Posted on 25th Jun, 2017
Peterbrura
http://domakostroma.com/
Posted on 02nd Jul, 2017
WaynePal
http://bit.ly/2tw1PvE
Posted on 09th Jul, 2017
TimothyFub
Hi there! cheapest mexican pharmacy online good web page.
Posted on 18th Aug, 2017
alaliaapolycl
Visit our website Alaliaa to take more information.
Posted on 02nd Sep, 2017
TimothyJet
http://haushaltshop.eu/ RekunsegeHeils
Posted on 14th Sep, 2017
masha2
Привет.
Posted on 25th Sep, 2017
AuigosTatty
Tramadols pills is employed to italian autostrada done with representing Buy Tramadol 150mg morose to regimen painstaking pain.
Tramadol, commonly known as Tramatas, Tranzex, buy generic ultram master Aurotrama and Tramol-SR is hand-me-down to lift normal to within via respectability of inexorable pain. It also may be euphemistic pre-owned to seat itch caused buy Ultram visa tramadols searching to surgery and long-lived conditions such as cancer or combined pain. ultram buy tramadol pills 100mg works sooner than decreasing the discernment's position and rejoin to pain. It also reduces the walk or immensity of the smarting order tramadol mastercard signal passed from inseparable obduracy to another. This medication is again prescribed as a substitute for of other uses; importune your doctor or posologist championing the allowances of more information.

Tramadol Ultram 50-200mg Order Online
Posted on 11th Oct, 2017
NIJesse
twvj.com
Posted on 03rd Nov, 2017
Corpoi87
osteoren recensioni


Nicely put. Regards!
Posted on 03rd Dec, 2017
Steklobanki-bug
Крышки для консервирования оптом в Твери
- Стеклобанки оптом


































































Promo Code: ABYRVALG251295



Posted on 10th Dec, 2017
KevinhaB
АлкоБарьер – эффективное средство борьбы с алкоголизмом

Устраняет тягу к алкоголю
Восстанавливает поврежденные клетки печени
Выводит токсины из организма
Успокаивает нервную систему
Не имеет вкуса и запаха

АЛКОБАРЬЕР – СКАЖИ «НЕТ» АЛКОЗАВИСИМОСТИ!

==>> ow.ly/Od8Z30g0Mg3
==>> is.gd/ORMsK8
Posted on 20th Dec, 2017
ClaudePt
Tranquilite, equilibre et robustesse sont les mots principaux qui definissent notre sélection de jouets pour enfants. Spécialistes de l’univers velo enfant et des jouets d'exterieur, avec jouetjeu.com, nous plebiscitons des jouets stables et tous manufactures en Europe, garantis au meilleur prix chaque mois.
Posted on 31st Dec, 2017
XRumerTest
Hello. And Bye.

Your Answer:

Login to answer
139 Like 16 Dislike
Previous forums Next forums
Other forums

how to populate a drop down box
Hi buddies!

PROCEDURE DOWNLOAD_REPORT_FORM (report_name varchar) is begin DOWNLO

What is SAP Avatar ?
Hi All,

This G.Satish , my boss asked me to explore on SAP Avatar. I searced in internet

output_buffering so rewrite
I'm planning to rewrite some of my scripts so they don't have to use output buffering to accomplish

Problem in OnClientClick and OnClick sync
Hi,Strange and irritating problem: I have below button declaration in markup of the aspx page:

Form errors in an array
I'm processing a form and putting the errors in an array. empty($errors) doesn't seem to do the tric

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Google+ Indyaspeak @ Pinterest RSS