Need help with MySQL / PHP Pagination

[MacDudeUK]

Been working at it for the last few hours and im sad to say im getting nowhere with it... Basic PHP / MySQL is easy but pagination ive never done...

Heres the code. I hope someone can help:




<?php
//This page display a topic
include ("includes/template/header.php");
if(isset($_GET['id']))
{
$id = intval($_GET['id']);
$dn1 = mysql_fetch_array(mysql_query('select count(t.id) as nb1, t.title, t.parent, count(t2.id) as nb2, c.name from topics as t, topics as t2, categories as c where t.id="'.$id.'" and t.id2=1 and t2.id="'.$id.'" and c.id=t.parent group by t.id'));
if($dn1['nb1']>0)
{
?>

<?php
if(isset($_SESSION['username']))
{
$nb_new_pm = mysql_fetch_array(mysql_query('select count(*) as nb_new_pm from pm where ((user1="'.$_SESSION['userid'].'" and user1read="no") or (user2="'.$_SESSION['userid'].'" and user2read="no")) and id2="1"'));
$nb_new_pm = $nb_new_pm['nb_new_pm'];
?>

<?php
}
else
{
?>

<?php
}
?>
<?php
if(isset($_SESSION['username']))
{
?>

<?php
}
$dn2 = mysql_query('select t.id2, t.authorid, t.message, t.timestamp, u.username as author, u.avatar from topics as t, users as u where t.id="'.$id.'" and u.id=t.authorid order by t.timestamp asc');
?>


<?php
while($dnn2 = mysql_fetch_array($dn2))
{
?>

<div class="row">
<div class="span2">
<div class="ddate">
<h5><i class="icon-calendar"></i> <?php echo date('d/m/Y'); ?></h5>
<div class="firstA"></div>
</div>
<div class="meta">

<span><?php
if($dnn2['avatar']!='')
{
echo '<img src="'.htmlentities($dnn2['avatar']).'" style="max-width:100px;max-height:100px;" />';
}
?><a href="profile.php?id=<?php echo $dnn2['authorid']; ?>"><h3 class="colored" align="center"><?php echo $dnn2['author']; ?></h3></a></span>
<center><span><strong><i class="icon-user"></i> Time Posted:</strong> <?php echo date(' H:i:s', $dnn2['timestamp']); ?></span></center>
</div>
<?php if(isset($_SESSION['username']) and $_SESSION['username']==$admin){ ?>
<hr>

<div class="addthis_toolbox addthis_default_style ">
<a class="btn btn-success" href="edit_message.php?id=<?php echo $id; ?>&id2=<?php echo $dnn2['id2']; ?>">Edit</a>
</div>
<hr>
<?php } ?>
</div>
<div class="span6">
<div class="blog_item">
<div class="blog_head">
<h3><?php echo $dn1['title']; ?></h3>
</div>
<p style="word-wrap: break-word;"><?=$dnn2['message'];?></p>
</div>
</div>
</div>

<?php
}
?>


<?php
if(isset($_SESSION['username']))
{
?>
<a class="btn btn-success pull-right" href="new_reply.php?id=<?php echo $id; ?>" >Reply</a>
<?php
}
else
{
?>


<div class="box_login">
<form action="login.php" method="post">
<label for="username">Username</label><input type="text" name="username" id="username" /><br />
<label for="password">Password</label><input type="password" name="password" id="password" /><br />
<label for="memorize">Remember</label><input type="checkbox" name="memorize" id="memorize" value="yes" />
<div class="center">
<input type="submit" value="Login" /> <input type="button" onclick="javascript:document.location='signup.php';" value="Sign Up" />
</div>
</form>
</div>
<?php
}
?><?php
}
else
{
echo '<h2>This topic doesn\'t exist.</h2>';
}
}
else
{
echo '<h2>The ID of this topic is not defined.</h2>';
}
?>

<div class="pagination">
<ul>
<li><a href="#">Prev</a></li>
<li class="active">
<a href="#">1</a>
</li>
<li><a href="#">2</a></li>
<li><a href="#">3</a></li>
<li><a href="#">4</a></li>
<li><a href="#">Next</a></li>
</ul>
</div>
<?php include ("includes/template/footer.php"); ?>
</div>



Ideally need like 5 entries to be displayed at a time.

Thanks in advance

[djr33]

There are lots of tutorials out there, and that's a good way to start with the basics to get it going the first time. After that, it's pretty easy to adjust what you need.

Personally I like this tutorial, but there are many more available if you don't :)
http://www.php-mysql-tutorial.com/wikis/php-tutorial/paging-using-php.aspx