RE: [PHP] paging methodology

From: Date: Tue, 04 May 2004 21:37:50 +0000
Subject: RE: [PHP] paging methodology
Groups: php.general 
Request: Send a blank email to php-general+get-185356@lists.php.net to get a copy of this message
John W. Holmes <mailto:holmes072000@charter.net> on Tuesday, May 04, 2004 1:30 PM said: > I don't follow what "$_GET record count from initial query performed > above;" is for, but that's the basic methodology. well that just meant that after the initial count of records is found it will be retrieved from the querystring instead of through a select statement (because it had already been performed once before). > The only thing to > note is that your first query should only use COUNT() and return the > number, not actually return the entire result set. ok. this is what i was already doing in my previous app but i was just looking to see if it could be streamlined some how. > With databases that do not support a LIMIT feature, then you will have > to return the entire result set and use a seek() function to jump to > the row you need (mssql_data_seek(), pg_data_seek(), etc). working with mysql so that's no problem. > Oh, you'll want to use <?php instead of <?chris... ;) Or is this > chris-general@lists.php.net?? i was working with the fabulous but little known chris scripting language. 'wget http://awesomewebsite.com.org/downloads/chris-1.0.rpm' thanks, chris.

« previous php.general (#185356) next »