basicly you need to do select .. limit $ptr, 1
and links prev = $ptr-1 (if $ptr!=0) and next = $ptr +1 (if $ptr <
select count(*))
Petre Agenbag wrote:
Rick,
thanks,
I will check the lists, but I'm not sure that will resolve my problem, I
don't want to limit the display in the initial
Hi Petre
Why not use LIMIT in your query? Like this:
".$sql['id']."";
}
//navigation
Echo"
".($prev>=0?"Previous
page":"")." ".($total_count>=$next+1?"Next page":"")."";
?>
I hope this helps you.
Best regards,
Davy Obdam
The Netherlands
mailto:info@;davyobdam.com
> -Oorspronkelijk
Rick,
thanks,
I will check the lists, but I'm not sure that will resolve my problem, I
don't want to limit the display in the initial result set, I want to
have a page that lists ALL the hits above each other, and it's only once
you click through to the next page that I want to start "walking"
th
This is a common requirement; check the archives and/or php.net, phpbuilder, etc.
What you will do is use mysql's LIMIT parameter on your select; go to mysql.com to read
about it.
Lets assume you wish to display 20 lines per page; assume you use a pointer, $ptr, to
determine where you are in a sea
PS, also, I would need to know and handle the beginning and end of that
array, ie, if there isn't a next or previous, I wouldn't want to display
a next or forward button, or maybe disable it...
Thanks
On Tue, 2002-10-29 at 14:06, Petre Agenbag wrote:
> Hi
> I need to do the following, and have a
5 matches
Mail list logo
