Pagination code needs a little work

[cjc1055]

I have the following working code. It displays 4 images per line, but will post an infinite number of photos on one page. How can I modify this code to put only 6 rows (24 photos) per page?

Thanks in advance,

Chris

	
<div class="center">
		<table class="table01">
<?php 
include 'connect.php';
$numInRow = 4;
$query = "SELECT * FROM mytable ORDER BY id DESC";
$result = mysql_query($query);
$num_rows=mysql_num_rows($result);

for ($i=0; $i<$num_rows; $i++){ 
if ($i % $numInRow == 0) { print ("<tr>"); } 
// fetch row 
$img_info = mysql_fetch_array($result); 
// start table row 
echo "<td><a href='imagelocation/$img_info[uniquename]' rel=\"lightbox[group]\" title=\"$img_info[name]\"><img src='imagelocation/$img_info[uniquename]' 
style=\"border:1px solid #FFFFFF\" alt=\"$img_info[name]\" title=\"$img_info[name]\" width=\"150\" height=\"150\" /></a>
					<br/><span style=\"font-size: 11px; line-height: 11px; \">$img_info[name]<br/>&nbsp;</span></td>"; 
if ($i % $numInRow == $numInRow-1) { print ("</tr>"); } 
} 
?>
			<tr><td><br/></td></tr>

	</table>
</div>

[dagon]

the usual approach would be to add a limit to the query, search this forum for pagination i know i have answered this in full in the past.

[cjc1055]

I've been checking and searching and have found a number of articles. I'm trying to find something that won't break my current code which is working as it should. I'll keep looking but if anyone has any tips for getting my code modified to work, I would appreciate it.

[Bonesnap]

What dagon said. You need to add the LIMIT clause to your query to accomplish this easily.

[cjc1055]

Ok, I've done that and this is where I'm at so far.
Still having a bit of difficulty...

<div class="center">
		<table class="table01">
<?php 
include 'connect.php';
$query = "SELECT * FROM mydatabase ORDER BY id DESC";
$result = mysql_query($query);
$num_rows=mysql_num_rows($result);
$numInRow = 4;
$numperpage = 24;
$last = ceil($num_rows/$numperpage);
	if (!(isset($pagenum))) 
        { 
        $pagenum = 1; 
        } 
        if ($pagenum < 1) 
        { 
        $pagenum = 1; 
        } 
        elseif ($pagenum > $last) 
        { 
        $pagenum = $last; 
        } 
		$max = 'limit ' .($pagenum - 1) * $numperpage .',' .$numperpage;
$pageresults = mysql_query("SELECT * FROM mydatabase ORDER BY id DESC $max") or die(mysql_error());
$page_num_rows=mysql_num_rows($pageresults);
for ($i=0; $i<$page_num_rows; $i++){ 
if ($i % $numInRow == 0) { print ("<tr>"); } 

$img_info = mysql_fetch_array($pageresults); 

echo "MY TABLE COLUMN GOES HERE"; 
if ($i % $numInRow == $numInRow-1) { print ("</tr>"); } 
} 
        if ($pagenum == 1) 
         { 
         } 
        else 
        { 
        echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'> <<-First</a> "; 
         echo " "; 
        $previous = $pagenum-1; 
        echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'> <-Previous</a> "; 
        } 


    if ($pagenum == $last) 
    { 
    } 
     else { 
     $next = $pagenum+1; 
     echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Next -></a> "; 
     echo " "; 
     echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last ->></a> "; 
     } 

?>
			<tr><td><br/></td></tr>

	</table>
</div>

[cjc1055]

Ok, I was missing a $_GET in the last post. I think I have it mostly figured out now.

[dagon]

you don't need a separate query just to get a row count, you can add SQL_CALC_FOUND_ROWS after the select in the query, it returns a row count, as if the limit was not there