I am not sure that any dbs will do that....i usually run two queries (one
for the limit data and one for the total rows)
Bastien
From: "chris smith" <[EMAIL PROTECTED]>
To: "Dwight Altman" <[EMAIL PROTECTED]>
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] LIMIT
Date: Sat, 1 Jul 2006 18:51:11 +1000
On 7/1/06, Dwight Altman <[EMAIL PROTECTED]> wrote:
Thanks, but that's an additional query.
I was wondering if there may be a PHP function that can operate on the
$result or perhaps $link of the single query that uses a LIMIT clause and
have the information [count(*) had there not been a LIMIT clause
"count_no_limit(*) maybe?" even though there was a LIMIT clause].
Something
like mysql_info.
Can the database do it like that? If the answer is no then there's no
way php can do it.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
