Paging - time out on final page

Mandakins

I've got a paging script and I think I have accidentally deleted something I needed. I'm getting this error on the last page only:

Fatal error: Maximum execution time of 30 seconds exceeded

I have it set to 28 records per page, and if the last page has fewer than 28 records I get that error. Do I need to set a different limit for the last page if there are fewer than 28 records? If so how?

Thanks in advance for any input

// Paging script

//if current page number, use it
//if not, set one!
if(!isset($GET['dfpage'])){
$dfpage = 1;
} else {
$dfpage = $GET['dfpage'];
}

//define the number of results per page
$max_results = 28;

//figure out the limit for the query based
//on the current page number.
$from = (($dfpage * $max_results) - $max_results);

//perform MySQL query on only the current page number's results

$mydfsql = "SELECT distinct PhotoNumber FROM Deadfred WHERE SubmitterEmail = '$email' order by PhotoNumber LIMIT $from, $max_results";
$sqlresult =mysql_query($mydfsql,$connection) or die("Couldn't run query.");

//figure out the total number of pages always round up using ceil
$sqlresultcnt =mysql_query("SELECT Count(distinct PhotoNumber) as mydfcount FROM Deadfred WHERE SubmitterEmail = '$email' ",$connection) or die("Couldn't get results count.");
while ($row= mysql_fetch_array($sqlresultcnt)) {
$mydfcount = $row['mydfcount'];
}
$total_pages = ceil($mydfcount / $max_results);

// ********* Display your results here ************************

//build previous link
if($dfpage > 1){
$prev = ($dfpage - 1);
$prevdisp = "<a href=\"".$_SERVER['PHP_SELF']."?dfpage=$prev\">Previous Page</a>";
}

// Get current page number and set Jump To pages
for($i = 1; $i <= $total_pages; $i++){
if(($dfpage) == $i){
echo "Page $i of $total_pages Pages</p>";
} else {
$jumpto = $jumpto ."<a href=\"".$_SERVER['PHP_SELF']."?dfpage=$i\">$i</a> ";
}
}

// Build Next Link
if($dfpage < $total_pages) {
$next = ($dfpage + 1);
$nextdisp = "<a href=\"".$_SERVER['PHP_SELF']."?dfpage=$next\">Next Page</a>";

}

?>

<?php
$x=0;
while ($x < $max_results){

while ($row = mysql_fetch_array($sqlresult)) {
$PhotoNumber = $row['PhotoNumber'];

if($x%4==0){
// close the row, open a new one
echo "</tr><tr valign = 'top'>";
}
echo "<td><div align=\"left\"><img src = \"http://www.deadfred.com/photos/$PhotoNumber.jpg\" width = \"150\" border = \"0\"></b></td>";
$x++;
} // end while loop
} // end for loop

</tr></table>
<p><?php echo "$prevdisp$nextdisp | Jump to page: $jumpto"; ?></p>