Paging results

[Anon]

anyone knows how to do paging in PHP - i've got to do a paging with results from a sql query.
eg: i get 40 rows from the query, but would
like to display only 8 at a time. I'm working with images in my database.
Plzz help

[Anon]

Hi!

If you use MySQL, then use LIMIT 0, 8 at the end of the SQL statement.

The first argument specifies 0 because enumeration in MySQL results starts with this number. 8 states the number of rows to return.

If you use other DBMS, you probably need to consult their references.

Best regards,
Stanislav

[Anon]

See this article here in PHPBuilder:

Building Next/Prev Buttons for Query Results
(http://www.phpbuilder.com/columns/rod20000221.php3)

Josemi