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" <dmagick@xxxxxxxxx>
To: "Dwight Altman" <dwight@xxxxxxxxxxxx>
CC: php-db@xxxxxxxxxxxxx
Subject: Re: LIMIT
Date: Sat, 1 Jul 2006 18:51:11 +1000
On 7/1/06, Dwight Altman <dwight@xxxxxxxxxxxx> 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
