in reply to What's the best way to get the first n rows, the second n rows... from a database?

The question is : what kind of db?

SELECT * FROM guests ORDER BY time DESC LIMIT 50

This is the sql line that's used for getting the first 50

In cgi I would make from 50 a variable so if somebody's pushes next(50) the variable would add 50.

Don't know how it's just done in perl. But I connected to the db with php to get what you wanted.

The best hint I can give is. Search on CPAN for DBI. Look to the perl-syntax how to connect to a db.
But most important is to know sql-syntax. Only then you can learn how to program databases(in any programming language).
--
My opinions may have changed,
but not the fact that I am right

  • Comment on Re: What's the best way to get the first n rows