|
|
Posted by Pavel on 03/24/05 23:55
> 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/
Navigation:
[Reply to this message]
|