in reply to how to put links on the bottom of an image gallery
Hi,
Why dont you try LIMIT in MySQL?
you can have your SQL as
here limit statement will limit the number of records returned. In limit statement, 1st numeric value is the first record to be returned (offset) and 2nd numeric value is the number of records (row count). i.e. LIMIT 0, 15 will return 1st 15 records ( 0th to 14th)LIMIT 15, 15will return next 15 records ( 15th to 29th) and so on. For more details pllease refer to SELECT SyntaxSELECT * FROM your_table ORDER BY id LIMIT 0, 15
Your link can be like "script.pl?page=0&orderby=id" page 1 | "script.pl?page=15&orderby=id" to enable pagination.
A step-by-step procedure to get pagination explained at Re: DB Search.
Cheers !
--VC
Updates :
Have a look at PerlMonks FAQ, The Perl Monks Guide to the Monastery for more information on how the Monastery works. How (Not) To Ask A Question will be a good guide. There are hundreds of thousands of posts here, Super Search is your friend. There are more than one postings available in the monastery regarding pagination
There are three sides to any argument.....
your side, my side and the right side.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: how to put links on the bottom of an image gallery
by sulfericacid (Deacon) on Aug 27, 2007 at 02:10 UTC | |
by atemon (Chaplain) on Aug 27, 2007 at 02:25 UTC | |
by misc (Friar) on Aug 27, 2007 at 10:08 UTC |
In Section
Seekers of Perl Wisdom