Listing X Amount of Items From A MySQL Database?

[jhale1966]

We have information that I display in tables in PHP. I need to be able to list 5 items per page (since 5 is the max amount that looks like it would fit on a page without running over into the next page.)

What is the easiest way to accomplish this?

Thanks!

[btherl]

You can order and limit your results.

[code=php:0]SELECT * FROM table
ORDER BY id ASC
LIMIT 0, 5[/code]


I think that's the correct Mysql limit syntax.  It means "start at row 0, and take 5 rows".  Note that you have to order your results by something unique to every row, otherwise you may get different orders from each request.  And that would mean your paging wouldn't work properly.

[jhale1966]

I guess I asked that wrong. :(

I have pages of data that come across but I need page breaks every 5 items so when we print it out, it doesn't run across the bottom/top margins.

[joshi_v]

Well! I guess pagination is what you need to do! right?

[fenway]

Pagination isn't hard in HTML.