|Problems? Is your data what you think it is?|
Re: how to put links on the bottom of an image galleryby atemon (Chaplain)
|on Aug 27, 2007 at 01:59 UTC||Need Help??|
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 Syntax
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.
There are three sides to any argument.....
your side, my side and the right side.