[RESOLVED] Fancy limit print

jerrylouise

ok i have two scripts im trying to muddle together.

This one here is a working script for printing out the results of a database query in a way that the results are split onto pages.

<?php
include 'include/session.php';

// how many rows to show per page
$rowsPerPage = 10;

// by default we show first page
$pageNum = 1;

// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
	$pageNum = $_GET['page'];
}

// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;

$query  = "SELECT title FROM storys LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed');

// print the random numbers
while($row = mysql_fetch_array($result))
{
}
echo '<br>';

// how many rows we have in database
$query   = "SELECT COUNT(title) AS numrows FROM storys";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];

// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);

// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav = '';
for($page = 1; $page <= $maxPage; $page++)
{
	if ($page == $pageNum)
	{
		$nav .= " $page ";   // no need to create a link to current page
	}
	else
	{
		$nav .= " <a href=\"$self?page=$page\">$page</a> ";
	}		
}



// print the navigation link
echo $nav;

?>

jerrylouise

This is the page im trying to integrate it on

	<body>

<!--Start page layout-->
<div id="page">
	<?php
		///Read the header file, this has the navagtion bar and logo///
		include("../page_blocks/header.php");
	?>
	<!--Main relates to the main content div for the entire page-->
	<div class="main">
			<!--Logged in - Not Logged in-->
				<?php if($session->logged_in){ ?>
		<!--The side bar is for elements like the clock and user logins-->
		<div class="side_bar">
								<?php
				///Shows the clock///
				///readfile("page_blocks/clock.php");
				///User Control Panel///
				include("../page_blocks/usercp.php");
				///contrib///
				include("../page_blocks/contrib.php");
				///chating time///
				include("../page_blocks/chat_time.php");
				///whos online///
			?>
				<div id="whoonline"><noscript><?php include("../page_blocks/noscript_whos_online.php");?></noscript></div>

	</div>
	<!--page main is the main area for displying information-->
	<div id="page_main">
<?php
// constents//
	// check if id is numberic //
		if (is_numeric($_GET['id'])) 
			{
				$id = stripslashes($_GET['id']);
			} 
		else 
			{
				$id = "1";
			}
	// end check if id is numberic //
	// check if category is nuberic // 
		if (is_numeric($_GET['category'])) 
			{
				$category_id = stripslashes($_GET['category']);
			} 
		else 
			{
				$category_id = stripslashes($_GET['category']);
			}
	// get the category title //
		$q = mysql_query ("SELECT `title`,`id` FROM `forum-topics` WHERE $category_id = `id`");	
		while ($row = mysql_fetch_assoc($q)) 
			{ 
				$category_title = stripslashes($row['title']);
			}
	// end category title //	
// update the forum veiws //
$query = mysql_query ("UPDATE `forum-posts` SET `views` = `views` + '1' WHERE `id` = '$id'");
// end update forum views //
////db connect
$name = "SELECT s.`id`, s.`post-id`, s.`username`, s.`date`, s.`subject`, s.`post`, s.`lastpost`, s.`lastposttime`, u.`username`, u.`avatar`, u.`userlevel` FROM `forum-posts` AS s LEFT JOIN `users` AS u ON s.username = u.username WHERE s.`id` = '$id' ORDER BY s.`id`";
$nameresult = mysql_query($name) or die("Query failed");
$pagename = mysql_fetch_array($nameresult);
// Nav bar //
echo '<div class="crumbs">';
echo "<div class=\"crumbs_btn\"><a href=\"reply.php?id=".$id."&category=".$category_id."&title=".($pagename['subject'])."\">New Reply</a></div>";
echo '<div class="crumb_bar"><div class="crumb_text">';
		echo "&nbsp;&nbsp;<a href=\"index.php\">Forum Index</a> / <a href=\"forum_topic.php?t=".$category_id."\">".$category_title."</a> / <font color=\"#000000\">".($pagename['subject'])."</font>";
echo '</div></div></div>';
// end nav bar //
/// logic to handle the last category  ///
// loop through records 
        // start a new content block 
	    echo '<div class="title"></div>'; 
        echo '<div class="content"><div class="content_text"><h3>'.($pagename['subject']).'</h3><br />';
// main topic content
$sql = "SELECT s.`id`, s.`post-id`, s.`username`, s.`date`, s.`subject`, s.`post`, s.`lastpost`, s.`lastposttime`, u.`username`, u.`avatar`, u.`userlevel` FROM `forum-posts` AS s LEFT JOIN `users` AS u ON s.username = u.username WHERE s.`id` = '$id' ORDER BY s.`id`";
$result = mysql_query($name) or die("Query failed($sql): " . mysql_error());
// topic//
if(mysql_num_rows($result)) // we got some results 
{  

   while($row = mysql_fetch_array($result)) 
   { 
   print '<div><table width="100%" cellpadding="3" cellspacing="5" >';

////row with avatar////
	///no avatar//
if ($row['avatar'] == '') { 
	printf('<tr><td class="border" valign="top" width="10%%" rowspan="3"><img class="forum_img" src="../images/profile_avatars/no_log.jpg" alt="profile_image_none" /></td>
			<td width="90%%">Posted by: %s</td></tr>', $row["username"]);
			}
elseif ($row['avatar'] == 'not entered') { 
	printf('<tr><td class="border" valign="top" width="10%%" rowspan="3"><img class="forum_img" src="../images/profile_avatars/no_log.jpg" alt="profile_image_none" /></td>
			<td width="90%%">Posted by: %s</td></tr>', $row["username"]);
			}
else { 
	printf('<tr><td class="border" valign="top" width="10%%" rowspan="2"><img class="forum_img" src="../images/profile_avatars/%s" alt="profile_image_%s" /></td>
			<td width="55%%">Posted on: %s</td><td width="35%%">By: %s</td></tr>', $row["avatar"], $row["avatar"], $row["date"], $row["username"]);
			}
///row with user data and forum data//
printf("<tr><td class=\"border\">Thread Starter</td><td valign=\"bottom\" class=\"border\"><span class=\"funtion\"><a href=\"../mail/sendmail.php?&user=%s\"><img src=\"../images/mail.jpg\" alt=\"mail\" width=\"20px\" height=\"20px\" valign=\"bottom\">Mail me</a> | <a href=\"../user_service/user_profile.php?&user=%s\"><img src=\"../images/friends.jpg\" alt=\"profile\" width=\"20px\" height=\"20px\" valign=\"bottom\">My Profile</a></tr>", $row["username"], $row["username"]);
////userlevels//////
echo '</table></div>';
printf("<div>%s" . "</div><br />", $row["post"]);
if ($usrname == $row[2] || $session->userlevel == '8' || $session->isAdmin()) { 
    print "<span class=\"button\"><a href=\"edit_topic.php?id=$id&category=$category_id&title=$category_title\">Edit</a></span>";
}
echo '</div></div>';       

	////for the while loop//
	}
}
// close the block for the last category 
echo '<div class="bottom_content"><div class="btm_text"></div></div>'; 
				/////////////////////content ends////////////////////////
//////////////////////////////////////////////////////////////////////////
/////////////////Replys//////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////
/// start ouput replys
$sql = "SELECT 
	replies.`id`, 
	replies.`reply-id`, 
	replies.`username`, 
	replies.`date`, 
	replies.`subject`, 
	replies.`post`, 
		n.`username`, 
		n.`avatar`, 
		n.`userlevel` 
FROM 
	`forum-reply` 
AS 
	`replies` 
LEFT JOIN 
	`users` 
AS 
	n 
ON 
	replies.username = n.username 
WHERE 
	replies.`reply-id` = '$id' 
ORDER BY 
	replies.`id`";
// replys//
$result = mysql_query($sql) or die("Query failed($sql): " . mysql_error());
if(mysql_num_rows($result)) // we got some results 
{  

   while($row = mysql_fetch_array($result)) 
   { 
	    echo '<div class="title"></div>'; 
        echo '<div class="content"><div class="content_text">';
   print '<div><table width="100%" cellpadding="3" cellspacing="5">';
	////row with avatar////
		///no avatar//
	if ($row['avatar'] == '') { 
		printf('<tr><td class="border" valign="top" width="10%%" rowspan="2"><img class="forum_img" src="../images/profile_avatars/no_log.jpg" alt="profile_image_none" /></td>
				<td width="55%%">Replyed on: %s</td><td width="35%%">By: %s</td></tr>', $row["date"], $row["username"]);
				}
	elseif ($row['avatar'] == 'not entered') { 
		printf('<tr><td class="border" valign="top" width="10%%" rowspan="2"><img class="forum_img" src="../images/profile_avatars/no_log.jpg" alt="profile_image_none" /></td>
				<td width="55%%">Replyed on: %s</td><td width="35%%">By: %s</td></tr>', $row["date"], $row["username"]);
				}
	else { 
		printf('<tr><td class="border" valign="top" width="10%%" rowspan="2"><img class="forum_img" src="../images/profile_avatars/%s" alt="profile_image_%s" /></td>
				<td width="55%%">Replyed on: %s</td><td width="35%%">By: %s</td></tr>', $row["avatar"], $row["avatar"], $row["date"], $row["username"]);
				}
	///row with user data and forum data//
	printf("<tr><td class=\"border\">Subject: %s</td><td valign=\"bottom\" class=\"border\"><span class=\"funtion\"><a href=\"../mail/sendmail.php?&user=%s\"><img src=\"../images/mail.jpg\" alt=\"mail\" width=\"20px\" height=\"20px\" valign=\"bottom\">Mail me</a> | <a href=\"../user_service/user_profile.php?&user=%s\"><img src=\"../images/friends.jpg\" alt=\"profile\" width=\"20px\" height=\"20px\" valign=\"bottom\">My Profile</a></tr>", $row["subject"], $row["username"], $row["username"]);////userlevels//////
echo '</table></div>';
printf("<div>%s" . "</div><br />", $row["post"]);
$reply = $row["id"];
if ($usrname == $row[2] || $session->userlevel == '8' || $session->isAdmin()) { 
    print "<span class=\"button\"><a href=\"edit_reply.php?id=$id&category=$category_id&title=".($pagename['subject'])."&replyid=$reply\">Edit</a></span>";
}
echo '</div></div>';       

	////for the while loop//
	// close the block for the last category 
echo '<div class="bottom_content"><div class="btm_text"></div></div>'; 
	}
// Nav bar //
echo '<div class="crumbs">';
echo "<div class=\"crumbs_btn\"><a href=\"reply.php?id=".$id."&category=".$category_id."&title=".($pagename['subject'])."\">New Reply</a></div>";
echo '<div class="crumb_bar"><div class="crumb_text">';
		echo "&nbsp;&nbsp;<a href=\"index.php\">Forum Index</a> / <a href=\"forum_topic.php?t=".$category_id."\">".$category_title."</a> / <font color=\"#000000\">".($pagename['subject'])."</font>";
echo '</div></div></div>';
// end nav bar //
}

			/////////////////////content ends////////////////////////

}

		else	{
					///not logged in///
						include("../page_blocks/login.php");
			/////////////////////content ends////////////////////////
				}
		?>		<!--end of main content div-->
	</div>
<!--Footer-->
	<?php
		readfile("../page_blocks/footer.php");
	?>
	<!--end of class main-->
	</div>
<!--end of class page-->
</div>
	</body>

jerrylouise

so simple lol its fixed

// close the block for the last category 
echo '<div class="bottom_content"><div class="btm_text"></div></div>'; 
				/////////////////////content ends////////////////////////
				// how many rows to show per page
$rowsPerPage = 2;

// by default we show first page
$pageNum = 1;

// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
	$pageNum = $_GET['page'];
}

// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
// how many rows we have in database
$query   = "SELECT  COUNT(`reply-id`) AS numrows FROM `forum-reply` WHERE `reply-id` = '$id'";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];

// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);

// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav = '';
for($page = 1; $page <= $maxPage; $page++)
{
	if ($page == $pageNum)
	{
		$nav .= " $page ";   // no need to create a link to current page
	}
	else
	{
		$nav .= " <a href=\"$self?page=$page&id=$id&category=$category_id&title=$category_title\">$page</a> ";
	}		
}
//////////////////////////////////////////////////////////////////////////
/////////////////Replys//////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////
/// start ouput replys
$sql = "SELECT 
	replies.`id`, 
	replies.`reply-id`, 
	replies.`username`, 
	replies.`date`, 
	replies.`subject`, 
	replies.`post`, 
		n.`username`, 
		n.`avatar`, 
		n.`userlevel` 
FROM 
	`forum-reply` 
AS 
	`replies` 
LEFT JOIN 
	`users` 
AS 
	n 
ON 
	replies.username = n.username 
WHERE 
	replies.`reply-id` = '$id' 
ORDER BY 
	replies.`id` LIMIT $offset, $rowsPerPage";
// replys//
$result = mysql_query($sql) or die("Query failed");
		echo "Page ".$nav."";
if(mysql_num_rows($result)) // we got some results 
{  

   while($row = mysql_fetch_array($result)) 
   { 
	    echo '<div class="title"></div>'; 
        echo '<div class="content"><div class="content_text">';
   print '<div><table width="100%" cellpadding="3" cellspacing="5">';
	////row with avatar////
		///no avatar//
	if ($row['avatar'] == '') { 
		printf('<tr><td class="border" valign="top" width="10%%" rowspan="2"><img class="forum_img" src="../images/profile_avatars/no_log.jpg" alt="profile_image_none" /></td>
				<td width="55%%">Replyed on: %s</td><td width="35%%">By: %s</td></tr>', $row["date"], $row["username"]);
				}
	elseif ($row['avatar'] == 'not entered') { 
		printf('<tr><td class="border" valign="top" width="10%%" rowspan="2"><img class="forum_img" src="../images/profile_avatars/no_log.jpg" alt="profile_image_none" /></td>
				<td width="55%%">Replyed on: %s</td><td width="35%%">By: %s</td></tr>', $row["date"], $row["username"]);
				}
	else { 
		printf('<tr><td class="border" valign="top" width="10%%" rowspan="2"><img class="forum_img" src="../images/profile_avatars/%s" alt="profile_image_%s" /></td>
				<td width="55%%">Replyed on: %s</td><td width="35%%">By: %s</td></tr>', $row["avatar"], $row["avatar"], $row["date"], $row["username"]);
				}
	///row with user data and forum data//
	printf("<tr><td class=\"border\">Subject: %s</td><td valign=\"bottom\" class=\"border\"><span class=\"funtion\"><a href=\"../mail/sendmail.php?&user=%s\"><img src=\"../images/mail.jpg\" alt=\"mail\" width=\"20px\" height=\"20px\" valign=\"bottom\">Mail me</a> | <a href=\"../user_service/user_profile.php?&user=%s\"><img src=\"../images/friends.jpg\" alt=\"profile\" width=\"20px\" height=\"20px\" valign=\"bottom\">My Profile</a></tr>", $row["subject"], $row["username"], $row["username"]);////userlevels//////
echo '</table></div>';
printf("<div>%s" . "</div><br />", $row["post"]);
$reply = $row["id"];
if ($usrname == $row[2] || $session->userlevel == '8' || $session->isAdmin()) { 
    print "<span class=\"button\"><a href=\"edit_reply.php?id=$id&category=$category_id&title=".($pagename['subject'])."&replyid=$reply\">Edit</a></span>";
}
echo '</div></div>';       

	////for the while loop//
	// close the block for the last category 
echo '<div class="bottom_content"><div class="btm_text"></div></div>'; 
	}
echo "Page ".$nav."";

// Nav bar //
echo '<div class="crumbs">';
echo "<div class=\"crumbs_btn\"><a href=\"reply.php?id=".$id."&category=".$category_id."&title=".($pagename['subject'])."\">New Reply</a></div>";
echo '<div class="crumb_bar"><div class="crumb_text">';
		echo "&nbsp;&nbsp;<a href=\"index.php\">Forum Index</a> / <a href=\"forum_topic.php?t=".$category_id."\">".$category_title."</a> / <font color=\"#000000\">".($pagename['subject'])."</font>";
echo '</div></div></div>';
// end nav bar //
}

			/////////////////////content ends////////////////////////

}