Posted by Colin Ross on 03/25/05 12:15

watch out for SQL injection attacks on that one though:

what if the 'user' went to "page.php?start=1;SELECT * from `mysql`;


On Thu, 24 Mar 2005 22:55:01 +0100, pavel <pavel@ogi.cz> wrote:
> > 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
>
>

[Back to original message]