forum pagination trouble?
Posted: Sun Apr 25, 2010 5:10 am
Hi im having trouble getting the topic replies to form in pagination results? please help.
Heres the code:
It does work but I want the replies just to appear for the correlating topic?, the next and previous page links appear above the replies?? and I want the topic to stay on every next or previous page?
Can anyone help? just this to do then can finally get the site up and running?
Thanks
Heres the code:
Code: Select all
<?php
$url=curPageURL();
//Connect to DB
include("connect.php");
// get value of id that sent from address bar
$web_id=$_GET['id'];
$searchresult=mysql_query("SELECT id, username, title, detail FROM forum_topic WHERE id='$web_id'") or die(mysql_error());
while($row=mysql_fetch_array($searchresult)) {
//the format is $variable = $r["nameofmysqlcolumn"];
//modify these to match your mysql table columns
$id = $row['id'];
$username = $row['username'];
$title = $row['title'];
$detail = $row['detail'];
echo "
<tr><td width='20'># $id</td><td width='100' align='center' valign='middle'><a href='forum-viewtopic.php?id=$id'><b>$username: </b></a></td>
<td valign='middle'><em>$title</em></td></tr>
<tr><td colspan='3'>$detail</td></tr>
<tr><td colspan='3'><hr size='1'></td></tr>";
}
?>
<p />
<?php
$limit = 2; //Number of results per page
$page=$_GET["page"]; //Get the page number to show
if($page == "") $page=1; //If no page number is set, the default page is 1
//Get the number of results
$searchresult=mysql_query("SELECT * FROM search ORDER BY id") or die(mysql_error());
$numberofresults=mysql_num_rows($searchresult);
//Get the number of pages
$numberofpages=ceil($numberofresults/$limit);
$searchresult=mysql_query("SELECT id, username, reply FROM forum_reply ORDER BY id LIMIT " . ($page-1)*$limit . ",$limit") or die(mysql_error());
while($row=mysql_fetch_array($searchresult)) {
//the format is $variable = $r["nameofmysqlcolumn"];
//modify these to match your mysql table columns
$id = $row['id'];
$username = $row['username'];
$reply = $row['reply'];
echo "
<tr><td width='100' align='center' valign='middle'><b>$username: </b></td>
<tr><td colspan='2'>$reply</td></tr>
<tr><td colspan='2'><hr size='1'></td></tr>";
}
$nav="";
if($page > 1) {
$nav .= "<a href=\"viewtopic.php?page=" . ($page-1) . "&searchstring=" .urlencode($searchstring) . "\"><< Prev</A>";
}
for($i = 1 ; $i <= $numberofpages ; $i++) {
if($i == $page) {
$nav .= "<b>$i</b>";
}else{
$nav .= "<a href=\"viewtopic.php?page=" . $i . "&searchstring=" .urlencode($searchstring) . "\"> $i </A>";
}
}
if($page < $numberofpages) {
$nav .= "<a href=\"viewtopic.php?page=" . ($page+1) . "&searchstring=" .urlencode($searchstring) . "\">Next >></A>";
}
Echo "<br><br>" . $nav;
?>Can anyone help? just this to do then can finally get the site up and running?
Thanks