Query question

[alfpalafox]

I have a table that contains 1000 entries, I need to show them in groups of fifty, how can I tell MySQL using PHP to show me the first group of 50 then the next and so on.

Thanks in advice

[Anon]

http://www.mysql.com/doc/S/E/SELECT.html

Use the LIMIT clause

[LIMIT [offset,] rows]

so to get the first 50

select item from table limit 0,50

to get the next 50

select item from table limit 50,50

to get the next 50

select item from table limit 100,50

[mattw]

Here's a tutorial on building previous and next links...

http://codewalkers.com/tutorials.php?show=4&page=1

Matt Wade
codewalkers.com