RE: [PHP] paging methodology
| From: | Chris W. Parker | 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.