$lastpage) { $pageno = $lastpage; } // if $limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page; $query = mysql_query("select * from files $limit") or die(mysql_error()); $count = 0; while ($sql = mysql_fetch_array($query)){ $name = $sql['name']; $description = $sql['description']; $thumbnail = $sql['thumbnail']; $file = $sql['file']; $id = $sql['id']; $count++; if ($count == 1){ echo ''; $count = 0; } } if ($count > 0){ echo ''; } if ($pageno == 1) { echo " FIRST PREV "; } else { echo " FIRST "; $prevpage = $pageno-1; echo " PREV "; } // if echo " ( Page $pageno of $lastpage ) "; if ($pageno == $lastpage) { echo " NEXT LAST "; } else { $nextpage = $pageno+1; echo " NEXT "; echo " LAST "; } // if ?>