> I am wanting to paginate records from a MySQL Database.
> I want there to be 5 records on a page, on multiple pages.
example for selecting page of records from mysql table:
$sql=sprintf("
SELECT SQL_CALC_FOUND_ROWS * FROM table LIMIT %d, %d",
$position*$records,
$records
);
after get count of all records:
$sql='SELECT FOUND_ROWS()';
> (I would like there to be a "next" and "previous.")
you can use http://pear.php.net/package/Pager
--
Pavel Vrany
http://ogi.cz/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
