Re: LIMIT

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@gmail.com> To: "Dwight Altman" <dwight@multicam.com> 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 <dwight@multicam.com> 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