Re: run query
| From: | @ Edwin | Date: | Tue, 10 Dec 2002 17:20:53 +0000 |
| Subject: | Re: run query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-127679@lists.php.net to get a copy of this message | ||
Or,
"Jon Haworth" <jhaworth@witanjardine.co.uk> wrote:
> Hi Diana,
>
> > After I run a query lik this,
> > $db->query($sql);
> >
> > what is the quickest way to find out how many
> > records result?
>
> Look into mysql_num_rows (or the equivalent if you're not using MySQL)
... you can even do it faster by using a
"select count(*) as something from some_table"
More info (found in the manual):
http://www.faqts.com/knowledge_base/view.phtml/aid/114/fid/12
HTH,
- E