How to limit output

Here is a question from a member in another forum:

I'm using PHP and MSSQL and would be very grateful if anyone can tell me how to limit the records displayed to say 25 in each page. Previously I had used PHP and MySQL and used the LIMIT function. I just can't find out how to do this in MSSQL. Any help would be very appreciated.

I also would like this answer, but for PHP and MySQL. I am trying to print cards, three to a page, from data in database. Currently the "cards" are being placed but some are cut in half. I just want three or four per page...

How to do this? I've seen examples of this before...
Help

SELECT TOP 25 * FROM tablename

I think thats it

By using the SELECT statement, I can limit the number of rows displayed, but with my particular need, I want to display all the data ( rows ) in a format that is easy to print... but they just aren't lining up. The output has the data going into a table. Three and 1/2 tables fit per page. If I select three per page, the person would have to go to each page then print to get all the "cards" printed. Since 3.5 fit per standard 8.5 x 11 page, I get a "card" cut in half, ugly and missing every fourth card.

I've been adjusting the size of the tables (cards) so that they fit when printed but it is difficult, every printer prints different.

Any ideas?

Are there printing options, like to print just three "cards" per page from the output page containing all the rows from database or query...

Hope I'm explaining this well.