displaying full database search

[Anon]

I am currently in the process of building an online store everything is fine, however I want to try and enhance how the information is displayed when a user displays for example a list of inkjet cartridges, at the present moment if a user wishes to display all the the epson cartridges it will display a full list however I would like this broken down into maybe displaying only maybe 10 at a time and then request the user to go to the next ten and so on until all has been viewed. all my backend for the site is php, and I seem to have got the hang of it, but I would like some help with this little query. web site address is www.freedompcs.co.uk if you need a look.

Thanks

[vponz]

Hi!

In MySql you can especify the number of rows you want to be returned by a query. For exemple.
SELECT * FROM TABLE_NAME LIMIT 1, 10;

This query will return the 10 first rows. When you want to retrive the next group, simply run this query:
SELECT * FROM TABLE LIMIT 11, 10

AND SO ON...

Review the Mysql Manual (Select syntax)