Limiting number of records on each page

NCC1701

Im trying to create a table that is populated by thumbnail size pics. Firstly i need only 12 pics per page, in a 3x4 grid, the problem is i dont know how to limit a number of records to a page and allow 'next page' and 'previous page' to display the next a previous page.

Also im not sure whether to store the images in a database or to store them in a directory but just store the image name in the database?

Can anyone help me on this? If i havent explained things clear enough just let me know.

NCC1701

Norman_Graham

Hi NCC

You want the LIMIT parameter in your MySQL query.

For previous/next code, search this forum. There are loads of threads on this topic, e.g. this one.

Finally, I recommend sticking the image path in your DB and not the image. Put the image files in a folder and record the path in its own field in the DB.

HTH

Norm

NCC1701

thank you that is very helpfull,

how can i display the image in the table when the image location is stored in the database and the actual image is stored in the /images/ directory?

RHolm

Have a column in your database table called img_src or something and have the relative path to the image

and then take the source out in a query and then have:

<img src="<? print $line['img_src']; ?>" alt="<? print $line['title']; ?>">