Help needed with PHP: Pagination in a tut system

[nitr0x]

Hey, i have made a tutorial system (Which is copyright and you are not allowed to use it as of yet, as i havn't released it... i may do in the near futre though.) But, now i have loads of tutorials being put on my web site, they are getting so far down the page, and I was wandering if someone could figure out a way to add a pagination to the pages, when you have clicked on a category to go to.

Here is the tutorial system:

<?php
include ("dbconnect.php");

switch ($view ) { // simple switch function
default: //states wat will show up if view doesn't = nething
$sql_query = "SELECT * FROM tutorials";
$result = mysql_query($sql_query);
$rows = mysql_num_rows($result);
echo "<center>There are currently <strong>($rows)</strong> tutorials all together<BR><BR></center>";
echo "<strong>Select type:</strong><br>";
echo "<a href=\"?nitr0x=tutorials/tutorials&view=all&sec=photoshop\">Photoshop</a> <br><a href=\"?nitr0x=tutorials/tutorials&view=all&sec=php\">PHP</a><br><a href=\"?nitr0x=tutorials/tutorials&view=all&sec=html\">HTML</a><br><a href=\"?nitr0x=tutorials/tutorials&view=all&sec=submitted\">Submitted</a>";
break; 

case "all":
$sec = $_GET["sec"];
$get = "SELECT * FROM `tutorials` WHERE section='$sec'";
$go = mysql_query($get);
 
while ($adam = mysql_fetch_array($go)) {


$color_1 = "#921414";
$color_2 = "#CC1C1C";
static $color;
if ($color == $color_1) {
$color = $color_2;
}
else {
$color = $color_1;
/// $color
}

/////////// HTML BIT GOES HERE
?>


<table width="100%" bgcolor="<? echo "$color"; ?>" border="0" cellspacing="0" cellpadding="0" style="border-style: dashed; border-width: 1; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1">
  <tr>
    <td><strong><? echo "$adam[title]"; ?></strong></td>
  </tr>
  <tr>
    <td>Submitted On: <? echo "$adam[date]"; ?></td>
  </tr>
  <tr>
    <td>Description: <? echo "$adam[description]"; ?></td>
  </tr>
  <tr>
    <td>Submitted By: <? echo "$adam[user]"; ?></td>
  </tr>
  <tr>
    <td><a href="?x=tutorials/tutorials&view=view&id=<? echo "$adam[ID]"; ?>">View Tutorial</a></td>
  </tr>
</table>
<br>

<?
//////////// END HTML PART
}
break; case "view":
$id = $_GET["id"]; // Sets the variable from the url - grabs the id # from url
$get = "SELECT * FROM `tutorials` WHERE ID='$id'";  // sql statement
$go = mysql_query($get); // retrieve the sql statment
while ($adam = mysql_fetch_array($go)) { // do this until finished
////////////// START HTML PARTS fOR VIEWING
?>
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><div align="right"><a href="?x=tutorials/tutorials"><strong>Tutorials</strong></a> 
        <strong>::</strong> <strong><? echo "<a href=\"?x=tutorials/tutorials&view=all&sec=$adam[section]\">$adam[section]</a>";
 ?></strong></div></td>
  </tr>
  <tr>
    <td><div align="center"><strong>:: <? echo "$adam[title]"; ?> ::</strong></div></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div align="left"><? echo "$adam[message]"; ?></div></td>
  </tr>
  <tr>
  <Td>
  <div align="right"><strong>Written by : <? echo "$adam[user]"; ?></strong></div>
  </Td>
  </tr>
</table>
<?
///////// END HTML PARTS FOR VIEWING OF TUTORIAL
}
}
?>

I'm guessing the pageination would be where the:

case "all":
$sec = $_GET["sec"];
$get = "SELECT * FROM `tutorials` WHERE section='$sec'";
$go = mysql_query($get);
 
while ($adam = mysql_fetch_array($go)) {


$color_1 = "#921414";
$color_2 = "#CC1C1C";
static $color;
if ($color == $color_1) {
$color = $color_2;
}
else {
$color = $color_1;
/// $color
}

/////////// HTML BIT GOES HERE
?>


<table width="100%" bgcolor="<? echo "$color"; ?>" border="0" cellspacing="0" cellpadding="0" style="border-style: dashed; border-width: 1; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1">
  <tr>
    <td><strong><? echo "$adam[title]"; ?></strong></td>
  </tr>
  <tr>
    <td>Submitted On: <? echo "$adam[date]"; ?></td>
  </tr>
  <tr>
    <td>Description: <? echo "$adam[description]"; ?></td>
  </tr>
  <tr>
    <td>Submitted By: <? echo "$adam[user]"; ?></td>
  </tr>
  <tr>
    <td><a href="?x=tutorials/tutorials&view=view&id=<? echo "$adam[ID]"; ?>">View Tutorial</a></td>
  </tr>
</table>

is... but i'm not too sure, if you can figure this out it would be so much appreciated, and you would get a mention on the site... and on the tutorial system if it gets released.

[ParaSnake]

You meant u need a pagination tut rite,try search this category (HTML / PHP / ASP / JS),i had posted a tut like that some where here,but its a long time ago,u may have to search if u wanna see it.
and thats my first time posting,so it contains many bugs,u could post it here so i can fix it.
thx

[ParaSnake]

Sorry for double post(for real,i do this to increase my post,who know?),but i remembered that my tut is used for plain txt database.
so i will give u a example,u can code ones base on this:

PHP Code:

//do some mysql conenct here
$a=mysql_query("SELECT * FROM tablename limit('".$begin."','".$end."') "); 


see the "limit" ?what it does is to limit the record that queried from the query $a.
for example i have these in my database name :
num - name
1 - scott
2 - bill
3 - sam
4 - peter
5 - george
so if i query it and i limit(2,3)
the return value will be bill,sam and peter.
so all you have to do is increse or decrease the variables $begin adn $end.

[Order]

Pagination can get pretty complicated, and is complex.

ParaSnake has the right idea though, you need to have a start and an offset. The start is where to begin, and the offset is how many you want to pull.

This is more of an SQL issue then php, here is some code to generate your links, use the LIMIT SQL statement to limit the results, I am only showing how to generate how many pages you will need.

PHP Code:

$count = "SELECT COUNT(*) FROM 'tutorials' WHERE section = '$sec'"; // We do not want to limit, since we want a full number.
$res = mysql_query($sql);
$count = mysql_fetch_array($res);
$pages = $count / 10; // Change 10 to your offset.
$pages = ceil($pages); // Rounds it up.
for($i=1;$i == $pages;$i++)
{
   $count = ($i * 10) + 1 // Change the 10 to your offset.
   echo "<a href='page.php?start=$count&offset=10'>$i</a>"; // Change 10 to offset.
}

// Done. 


Not the greatest sample, but is simple.. those will generate your page links, it is up to you to use SQL LIMIT to get the proper results.