Array

Anon

I'm making some kind of pic gallery with php and so far, i'm able to get all the pictures down from the database...wel only the first 25[rows:5 - PicPerRow:4] and now i need to get the menu down. I have 66 pics total meaning i should have 3 pages where the last page has only 16 pictures. I want it flexible so if i add or take out pics, it'll add or take out pages. I got that part down but the major problem is...how do i start retrieving information from a certain part of the mysql_fetch_array? Cuz when I click on page 2, it shows the same pictures of page 1 which is of course not a good thing and I want this all done on one .php page- I know it could be done but I probably don't have the PHP experience. Anybody know what I could do?

Thanks.

-phpNewb[Gad]

nevermore2181

My friend, Fritzy, has dealt with that issue in his project PMIDD--which will soon be released on SourceForge. Check out his work at http://www.fritzyandfriends.com/pmidd/

He might be able to either a.) share the source of his work with you, or b.) explain how he toppled that problem.

Anon

mkay, that really didn't help me but thanks. that PMIDD is exactly what i'm trying to do.

dannys

You need to look at MySQL's LIMIT command.

Taken from the MySQL manual:

Here is an example of how to use Limit:

The first example will limit the result to the first 10 items.
SELECT name FROM customers LIMIT 10

This example will limit the result to 10 rows, starting with row 5.
SELECT name FROM customers LIMIT 5 , 10

If you only use one parameter, it will be the number of rows to return, if you use two parameters, it will be where to start, and then the number to return.