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.

Your Answer:

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

Timberland 6 Inch Bottes En Blanc Noir - €110.67 : Timberland outlet, timberlandschoenen.cn
[b][url=http://www.timberlandschoenen.cn/fr/]timberland boots noires[/url][/b] [b][url=http://www.ti

what does this mean? +=
is anyone able to explain what this code is saying?

i had it written for me awhile back and n

ORA-01017: invalid username/password; logon denied
Dear All,

I am facing problem in taken backup from db13 it comes up with the following l

Casting Decimals in Oracle
This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Ora

Copy Watches ROLEX OYSTER PERPETUALMILGAUSS 116400GV - $215.00 : Professional replica watches stores, discountwatches.top
[b][url=http://www.discountwatches.top/]best swiss replica watches[/url][/b] [b][url=http://www.dis

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