php - How do I set up pagination for an image gallery with image thumbnails? -

I have two tables:

  gallery id | Name | Details Image ID | Title | Caption | Gallery ID  

By listing all thumbnails or paging through thumbnails I got the code to create a simple image gallery. However, what I need to do is here something like gallery here Only completes without javascript and ajax:

I want a selection number to show below the main image as soon as the user clicks the thumbnail, the page Selected new Highlight the image and the series of thumbnails on boto goes forward one by one if its not the last image.

How do I do this? Do I need a quick and dirty way to do this? I am using php and mysql for the database here - just need code to show 'paged' images below the main image. I know how to install everything i.e. Thumbnail size etc ...

I do not know the number of your rows in MySQL for T-SQL As there is a ROWNUMBER () function, but to do this, it is a smart way to sequential numbering of your images in the database. From there, you ask something from your database by asking:

SELECT TOP [images_per_page] where line_number> [images_per_page] * [page_member-1].

In this way you can only pull back the data you need. You can keep track of the page number in your query string.

It is very simple, but hopefully it gives you the idea of ​​starting.