I've got a simple database to keep some emails, Can there be any method of getting your email in the database in categories of one hundred emails ???

This is actually the database structure

Table structure for table `emails`
--

CREATE TABLE IF NOT EXISTS `emails` (
  `email` varchar(100) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `timestamp` datetime NOT NULL,
  PRIMARY KEY  (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

The perfect outcome is always to obtain the first 100 emails, make a move and then obtain the next 100 and make a move else.

Thanks and sorry for my british

LIMIT 100

http://dev.mysql.com/doc/refman/5.1/en/select.html#id827984

Then for the following one, LIMIT 100, 100, after which LIMIT 200, 100, and so forth.

The very first number (when you will find two) may be the offset.

Make use of the SQL [cde] syntax to paginate via SQL.

Presuming that you will be exhibiting these results on the web page, I'd also recommend that you employ a PHP library like [cde] to assist you because well. There's a great lessons here.

One factor to notice, for performance reasons, you need to make sure that you are utilizing LIMIT <offset>, <row_count> inside your paginated query which you're utilizing an index. The MySQL Performance blog includes a good explanation.