PHP Pagination Class

Dear Imad Jomaa,

Thank you very much for your quick response. I found the solution in the file you sent me. i had

$pagination = new Pagination($limit, $rows, $page, $location);

instead of

$pagination = new Pagination(5, $rows, $page, “http://www.website.com/something.php?page”);

Once again, Thank you.

The script is brilliant and looks very good.

All the best,

wdlb

hey ImadJomaa could you help me please? can’t go to the next page there is Warning: mysql_num_rows() expects parameter 1 to be resource, null given in here is my code <?php

define(“IN_PAGI”, true); require(“class_pagination.php”); //grab the current page $page = intval($_GET[‘page’]); //set the page if empty if(empty($page)) { $page = 1; }

$rows = mysql_num_rows($result); $Location=”http://localhost/ez-users-with-facebook-integration/Herren.php?page”; $pagination = new Pagination(5, $rows, $page, $Location); $start = $pagination->prePagination(); $result = mysql_query(“SELECT * From artikel Where cat>6 LIMIT $start, 5”); echo “”; echo ”<center>$rows[Artikelbezeichnung]</center>”; echo “
”; echo ”<center> $rows[Datum] </center>”; echo “
”; echo “
”; echo “ ”; }

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

$pagination->pagination(); ?>

thanks for your fast reply there is no error code but he didn’t move to the next page

$pagination = new Pagination(5, mysql_query(“SELECT * From artikel Where cat>6”), $page, “http://localhost/ez-users-with-facebook-integration/Herren.php?page”); $start = $pagination->prePagination(); $query = mysql_query(“SELECT * From artikel Where cat>6 LIMIT $start, 3”); echo “”; echo ”<center>$row[Artikelbezeichnung]</center>”; echo ”<right>$row[Stylepoints]</right>”; echo “
”; echo ”<center> $row[Datum] </center>”; echo “
”; echo “
”; echo “ ”; }

while  ($row = mysql_fetch_assoc($query)) {

$pagination->pagination(); ?>

could I use this script with wordpress for a home page? I know there are functions and plugins for wordpress however for this project in a Wordpress MU environment I have needed to do some direct sql queries and not able to use the default pagination. Will your class create the extra pages on a home page in Wordpress? Thank you

This is all very confusing. I can not get anything to work. I have been trying for the comments but nothing helps. Too bad …