How to use pagination with PHP and MySQL

[gamernaveen]

What this does is , take those results form the database and print them in tab like fashion. What I want to do is ,

1) Set a range , example 6
2) Display only 6 results after which I want "NEXT PAGE"
3) Again display 6 results with "PREVIOUS PAGE" and "NEXT PAGE"

I wanna add pagination to this. how can I do this?

            <?php
              $count=0;
            //$level = 4;
            $levels_per_tier = 7;
 
            $tier = $_GET['tier'];
            if(!$tier){$tier = 1;}
 
            $result = db_execute_return("Select MAX(level) from jobs;");
            list($count_levels) = mysql_fetch_array($result);
            $remin = $count_levels%7;
            $count_ = $count_levels - $remin;
            $count_ = $count_/7;
            if($remin){$count_++;}
            for($i=1;$i<=$count_;$i++){
 
                $astart ="";$aend="";$cur="";
                if($i == $tier){$cur = "leveltier_clicked";}
                $start = ($i*7)-6;
                $res = db_execute_return("Select name from level where id= ".$start.";");
                list($levelname) = mysql_fetch_array($res);
                $end = ($i*7);
                if($end > $count_levels){$end = $count_levels;}
                if($level >= $start){
                    $stat = $levelname;
                    $astart = '<a href="?tier='.$i.'">';
                    $aend = '</a>';
                }else{
                    $stat = "LOCKED";
                }
                echo $astart ;
 
$lvldisp='Levels';
$nxdisp=$start." - ".$end."<br/>".$stat;
                ?>
                <div class="leveltier <?= $cur;?>">
                    <? echo $lvldisp.$nxdisp;?>
                </div>
 
                <?php
                echo $aend ;
            }