Mod_rewrite & Pagination

crazyryan · 12-08-2007, 09:22 AM

Right, this is where I'm at ..

PHP Code:


			
$total = mysql_query("select count(*) from games where id ='$id'");

$tot = mysql_result($total, 0);

        

if (is_numeric($_GET['page'])){

$page = $_GET['page'];

}else{

$page = 1;

}



$limit = 1;



$start = ($page * $limit) - $limit;



$query = mysql_query("select * from games where catid = '$id' LIMIT $start, $limit");

I'm just having problems showing the correct links, e.g.

PHP Code:


			
if ((($start * $page) - $limit) > 0){

            $page = $page-1;

   echo '<a href="/category/' . $id . '/page-' . $page . '.html">Previous</a>';

               $page = $page+1;

            }

            

            if (($start * $page) < $tot){

            $page = $page+1;

   echo '<a href="/category/' . $id . '/page-' . $page . '.html">Next</a>';

   $page = $page-1;

}

That works fine, kind of, it shows next and it shows previous, but it never shows them both at the same time, so I only ever get 2 pages of results.

Anyone know why?

Rendair · 12-08-2007, 09:38 AM

wouldn't it be easier to put

PHP Code:


			
if ($page > 1){
          
   echo '<a href="/category/' . $id . '/page-' . $page-1 . '.html">Previous</a>';
        
            }
            
if ($start < $tot){
   
   echo '<a href="/category/' . $id . '/page-' . $page+1 . '.html">Next</a>';
 
}

crazyryan · 12-08-2007, 09:41 AM

I'm not sure, but even still .. it doesnt show next/previous on 1 page.

Haris · 12-08-2007, 09:57 AM

php Code:

if ($page > 1){
          
   echo '<a href="/category/' . $id . '/page-' . $page-1 . '.html">Previous</a>';
        
            }
            
if ($start =< $tot){
   
   echo '<a href="/category/' . $id . '/page-' . $page+1 . '.html">Next</a>';
 
}

You should refer to How to paginate the fetched data from the database?

crazyryan · 12-08-2007, 10:00 AM

Thanks, that helps a bit, I've set my limit to 1 for testing and I have 5 rows, and it only goes up to page 3 and then says previous again.

Haris · 12-08-2007, 10:02 AM

Quote:

Originally Posted by crazyryan

Thanks, that helps a bit, I've set my limit to 1 for testing and I have 5 rows, and it only goes up to page 3 and then says previous again.

Post Updated.

Edit: Does $tot returns 5?

Edit2: Why are you decreasing 1 from $start on every page? $start = ($page * $limit) - $limit;

crazyryan · 12-08-2007, 10:18 AM

Okay, turns out I had an error in my query.

Your thing works Haris almost, it shows one extra next when it's not needed.

crazyryan · 12-09-2007, 01:47 PM

Bump, any solution to my post above?

maZtah · 12-11-2007, 09:23 AM

Please note that mysql_result is 'deprecated'/very slow and therefore you should use the following function to get your results:

PHP Code:


			
$aRow = mysql_fetch_array($pTotal, MYSQL_NUM);

$iTotal = $aRow[0];

Edit: Also you could better do COUNT(Id) instead of COUNT(*). It saves resources/memory and will be quicker.