Re: Best way to tell how many rows a query returns
| From: | HKG) | Date: | Wed, 12 May 2004 09:34:11 +0000 |
| Subject: | Re: Best way to tell how many rows a query returns | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-23683@lists.php.net to get a copy of this message | ||
> Say there are 200 records that match 'conditions', only 30 rows are
> returned (of course). How do I find out the total number (200 in this case)
> that matched the conditions?
>
> Any ideas?
SELECT COUNT(*) ....