MySQL LIMIT based on records

[Anon]

I am trying to create a page that lists records, but I want it to show only 30 records at a time. I know how to do that, but my question is, how do I make the footer that lists how many pages there are?

Example:

There are 87 records, and it show 30 records at a time.

The footer would look like:
[1] [2] [3]

When [1] is selected it shows the first 30, and then so on for the others.

How can I set this dynamically, so that as it gets to more than 90 records, it automatically adds a [4]?

[Anon]

Well you could just use a second query that does a count(*). The count() function is usually very optomized so it shouldn't add much if any overhead to your program.