Next page function

[Anon]

I have a site (www.acidsun.com) and it has a tutorial archive on it. Tutorials can get mighty long just to have on one page, so I want to make it multiple pages for one tute. I know there is a possible way to do it by having php count the charaters and have so many on each page and then divide the rest, and I dont know if you could just count the number of lines. How does phpbuilder.com do it?

[[deleted]]

Pagebreaks probably.
Just a keyword to identify the start of page one, two, three etc...
Then if you want page two, you just print from pagebreak2 to pagebreak3

[cordex]

Counting characters is a possibility, but unless the lines were all separated by linebreaks or <BR> tags, counting lines would be a bit more of an issue.

I agree with vincent - use some sort of page break keyword, preferably with an identifier so you can jump directly to a section of the tutorial.

-Ben

[Anon]

Sooo, I think I get what you mean. I type up my tutorial, and where ever I want a new page I just put <br> and then have php pick up on the tags, so when it sees <br> it will automaticlly create a new page for the remaining text? I'll try it, see if I can get it going.

Thanx (i never thought of that)

[[deleted]]

Something like that, but ofcourse you'd never use the BR tag, because you'll want to use the RB tag in your tut too.

Use something like
[pagebreak]

Or as I have done a while back;
[pagebreak "titel of the chapter"]
It is not very likely that you'll put something like that in the tutorial for real, plus you can very easily get the names of the chapters/pages to list so people can jump straight to the pages.

[Anon]

Ok I got the idea now, but I am having trouble with starting out some code. I am using MySQL and here is what I have for code right now (its really messy i think):

<?php

$user="user";
$pass="password";
$db="database";
$link=mysql_connect("localhost",$user,$pass);
if(!$link)
die("Couldn't connect to MySQL.");
mysql_select_db($db,$link)
or die("Couldn't open $db: ".mysql_error());

							if(isset($id) && !empty($id))
							{
							$result=mysql_query("SELECT * FROM tutorials WHERE id=$id");
							$result2=mysql_query("SELECT * FROM tute_comments WHERE tute_id=$id");
							$num_comnts=mysql_num_rows($result2);
							while($a_row=mysql_fetch_array($result))
							{
							$newview=$a_row[views]+1;
							$query="UPDATE tutorials SET views='$newview' where id=$id";
							mysql_query($query);
							print"<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
									<tr> 
									 <td><b>$a_row[title]</b></td>
									</tr>
									<tr> 
										<td> 
  										<p>$a_row[body]</p>//Prints body of the tutorial
  										</td>
									</tr>
									 <tr>
										<td><font color=\"#999999\" size=\"2\">Posted by <a href=\"mailto:$a_row[auth_email]\">$a_row[auth_name]</a> 
  										on $a_row[date] with $a_row[views] views and <a href=\"http://acidsun.com/read_comnt.php?id=$a_row[id]\"><u>$num_comnts comments</u></a> [<a href=\"http://acidsun.com/post_comnt.php?id=$a_row[id]\"><u>post comment</u></a>]</font></td>
									</tr>
									 <tr> 
										<td>&nbsp;</td>
									</tr>
									</table>";
							}
							}
							else
							{
							$result=mysql_query("SELECT * FROM tutorials ORDER BY id DESC");
							while($a_row=mysql_fetch_array($result))
							{
							$result2=mysql_query("SELECT * FROM tute_comments WHERE tute_id=$a_row[id]");
							$num_comnts2=mysql_num_rows($result2);
							print"<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
									<tr> 
										<td><b><a href=\"http://acidsun.com/$page?id=$a_row[id]\"><u>$a_row[title]</u></a></b></td>
									</tr>
									<tr> 
										<td> 
  										<p>$a_row[description]</p>
  										</td>
									</tr>
									<tr> 
										<td><font color=\"#999999\" size=\"2\">Posted by <a href=\"mailto:$a_row[auth_email]\">$a_row[auth_name]</a> 
  										on $a_row[date] with $a_row[views] views and <a href=\"http://acidsun.com/read_comnt.php?id=$a_row[id]\"><u>$num_comnts2 comments</u></a> [<a href=\"http://acidsun.com/post_comnt.php?id=$a_row[id]\"><u>post comment</u></a>]</font></td>
									</tr>
									<tr> 
										<td>&nbsp;</td>
									</tr>
									</table>";
							}
							}
							mysql_close($link);
						  ?>