# Displaying multiple pages

**URL:** https://forum.kirupa.com/t/displaying-multiple-pages/131185
**Category:** Uncategorized
**Created:** [December 13, 2004, 5:16am UTC](https://forum.kirupa.com/t/displaying-multiple-pages/131185 "2004-12-13T05:16:26Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Rockstar](https://avatars.discourse-cdn.com/v4/letter/r/73ab20/32.png) [@Rockstar](https://forum.kirupa.com/u/Rockstar)
#### Post date: [December 13, 2004, 5:16am UTC](https://forum.kirupa.com/t/displaying-multiple-pages/131185/1 "2004-12-13T05:16:26Z")

</div>

I understand the logic, however assigning it to the buttons thats the part that I dont understand. I came up with this script, however it doesnt work, any ideas?

$start = 0;  
$limit = 2;

$query = “SELECT id, msg, DATE\_FORMAT(date, ‘%M %D, %Y’) as formatted\_date, TIME\_FORMAT(time, ‘%l:%i:%p’) as timeNow FROM blog LIMIT $start, $limit”;  
$query\_result = mysql\_query($query);

```
while ($row = mysql_fetch_array($query_result)) {
	$content .= "
		&lt;table&gt;
			&lt;tr&gt;&lt;td valign=\"top\"&gt;Message: &lt;/td&gt;&lt;td&gt;$row[msg]&lt;P&gt;&lt;/P&gt;&lt;/td&gt;&lt;/tr&gt;

			&lt;tr&gt;&lt;td&gt;$row[formatted_date]&lt;/td&gt;&lt;/tr&gt;

			&lt;tr&gt;&lt;td&gt;$row[timeNow]&lt;/td&gt;&lt;/tr&gt;

			&lt;tr&gt;&lt;td&gt;&lt;a href = \"reply.php?topic_id=$row[id]\"&gt;reply?&lt;/a&gt;&lt;/td&gt;
			&lt;td&gt;&lt;a href = \"detail_blogs.php?topic_id=$row[id]\"&gt;detail blogs&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;

		&lt;/table&gt;&lt;p&gt;&lt;/P&gt;&lt;br&gt;&lt;br&gt;";	

```

};[//reply.php](https://reply.php) is hit, this will be sent as topic\_idx to the next page which is reply.php

$content .= ‘\<A HREF=view\_blogs.php?start=", $start - 2, "\> Prev\</A\>’;  
$content .= ‘\<A HREF=view\_blogs.php?start=", $start + 2, "\> Next\</A\>’;