Hi all

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
PU43X
Forum Newbie
Posts: 2
Joined: Wed Aug 06, 2003 7:38 am
Location: England

Hi all

Post 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
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

Have a look at MySQL's LIMIT (esp. the user notes).
User avatar
Donno
Forum Newbie
Posts: 1
Joined: Wed Aug 06, 2003 8:11 am
Location: Dublin, Ireland

Post by Donno »

PU43X
Forum Newbie
Posts: 2
Joined: Wed Aug 06, 2003 7:38 am
Location: England

Post 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!
Post Reply