Page 1 of 1

Hi all

Posted: Wed Aug 06, 2003 7:38 am
by PU43X
This is my first post on here so be nice :p

I'm pretty no.sh to PHP and was wondering if i could ask a question!

I've got a list of around 200 records (which are for pictures) in a MySQL database and was wondering how to diplay them all over several pages? Say on the first page 20 thumbnails are display, click next and the next 20 are displayed and so on!

many thanks

PU43X

Posted: Wed Aug 06, 2003 8:09 am
by patrikG
Have a look at MySQL's LIMIT (esp. the user notes).

Posted: Wed Aug 06, 2003 8:11 am
by Donno

Posted: Wed Aug 06, 2003 8:17 am
by PU43X
cheers for the replies. I think i can do it now!

I have one small question again. :p

how can i run the query on the same page without using variable?

link would look like

http://www.mydomian.com/gallery.php?viewall

instead of

http://www.mydomain.com/gallery.php?imageid=1

hope that makes sense!