Pagination

[TechnoPanda]

I have this script:

<?php
session_start();
require ("connect.php");
require("functions.php"); 
include("template/header.php");

    $username = $_SESSION['username'];
    $uid = $_SESSION['id'];

    $cat = $_GET['layouts'];

    $uid = $_SESSION['id'];
    if($cat == "none"){
    $result = mysql_query("SELECT * from layouts ORDER BY `id` ASC");   
    }else{
    $result = mysql_query("SELECT * from layouts WHERE categoryID='$cat'");
    }

    while($list = mysql_fetch_array( $result )){

$no_results = TRUE;   // No results found yet
$howmany    = 4;     // Return 10 results per query
 
// Set default starting point of query to 0, or, if set, to $_GET['rs']
$row_start  = (isset($_GET['rs'])) ? $_GET['rs'] : 0;
 
 
// Do our SQL query, with something like LIMIT 0, 10
$sql    = "SELECT SQL_CALC_FOUND_ROWS title, previewlink, image FROM layouts LIMIT ". $row_start .", ". $howmany ."";
$result = mysql_query($sql);
 
 
// Get the number of rows that would have been returned WITHOUT a limit clause, to be used later for paging.
$count_sql        = "SELECT FOUND_ROWS() AS total";
$count_sql_result = mysql_query($count_sql);
$count_row       = mysql_fetch_array($count_sql_result);
$count_result       = $count_row['total'];
 
// Start looping through our result set
while($row = mysql_fetch_array($result)) {
    $no_results = FALSE;
 
    // Save results of query to $line_output
    $line_output .= "


       <style>.button {
        margin-top: 0px;
    display:block;
    width:250px;
    height:50px;
    text-indent:-9999px;
    margin-left: 300px;
    }
    .button a {
    display:block;
    width:100%;
    height:100%;
    background:url(images/save.png) no-repeat top left;
    outline:none;
    }
    .button a:hover {
    background-position:0 -50px;
    }
    .button2 {
    margin-top: 0px;
    display:block;
    width:250px;
    height:50px;
    text-indent:-9999px;
    margin-left: 300px;
    }
    .button2 a {
    display:block;
    width:100%;
    height:100%;
    background:url(images/preview.png) no-repeat top left;
    outline:none;
    }
    .button2 a:hover {
    background-position:0 -50px;
    }
    #cats {
    width: 100px;
    height: 100px;
    margin: 5px;
    float: left;
    margin-left: 50px;
    }
    #layouts {
    background: url('images/backdrop.png');
    width: 609px;
    height: 190px;
    margin-left: 50px;
    }
    #next {
    margin-left: 50px;
    }
    </style>";
        echo "<div id=\"layouts\"><br/><br/><div id=\"cats\"><img align=\"left\" src=\"images/";
        echo $row['image'];
        echo "\" width=\"100px\" height=\"100px\" border=\"1px\">";
        echo $row['title'];
        echo "</div><p class=\"button2\">";
        echo "<a href=\"";
    echo "twitterpreview.php?image=images/";
        echo $row['image'];
        echo "\" target=_blank\">";
        echo "Preview Twitter Background";
        echo "</a> ";
        echo "</p>";
        echo "<p class=\"button\">";
        echo "<a href=\"";
        echo "downloadimage.php?image=images/";
        echo $row['image'];
        echo "\">";
        echo "Save Image";
        echo "</a> ";
        echo "</p></div>";
}}
// Don't bother building paging if we don't have records
if ($no_results) {
    $line_output = "No records found...";
    $page_output = "";
}
else {
    // Build <prev> and <next> links and save to $page_output
    $rs_prev = $row_start - $howmany; // where would prev page start, given current start less no. of records
    $rs_next = $row_start + $howmany; // where would next page start, given current start plus no. of records
 
    // If for some reason the next <prev> starting point is negative, do not display <prev>
    // This happens when our current starting point is already 0
    // This may happen if some smartass manually changes the rs= bit in the url
    $page_output_prev     = ($rs_prev < 0) ? "" : "<div id=\"next\"><a href='?layouts=".$cat."?rs=".$rs_previous."'>Previous</a></div>";
 
    // Will the next page jump start point exceed the number of records returned?
    // If so, don't display <next>'
    $page_output_next     = ($rs_next >= $count_result) ? "" : "<div id=\"next\"><a href='?layouts=".$cat."?rs=".$rs_next."'>Next</a></div>";
 
    // Just something to put between <prev> & <next>, IF they are both active
    if (($page_output_prev == "") || ($page_output_next == "")) {$page_output_breaker = "";}
    else { $page_output_breaker = " || ";}
 
    // Build final paging output
    $page_output = $page_output_prev . $page_output_breaker . $page_output_next;
}
 
// Write the outputs
echo $line_output;
echo $page_output;
 


    
    include("template/footer.php");
?>

It basically takes the info from the database and paginates it. Each set of data is in a category however the url is like

http://www.mysite.com/layouts.php?layouts=14

when I would like it to go to the next page it goes to

http://www.mysite.com/layouts.php?layouts=14?rs=4

and then to

http://www.freetweetgraphics.com/layouts.php?layouts=14?rs=4?rs=4

etc. etc. all I get is 4 display results (which are the same each time) on each page.

How do i get it to update to the next 4 peices of data from each category?

[Blob]

?rs=8

not ?rs=4?rs=4

[TechnoPanda]

I know that is what needs to be done however I don't know who to make it do that.

Also I now have another problem now. Say if I added a layout to category 14, 12 and 9 all three layouts will show up in each category.