RE: [PHP] run query
| From: | Rich Gray | Date: | Tue, 10 Dec 2002 17:36:31 +0000 |
| Subject: | RE: [PHP] run query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-127682@lists.php.net to get a copy of this message | ||
Er... but the original poster wanted a count of rows returned by a
particular query... your method just returns the number of rows in the
table...
Rich
-----Original Message-----
From: @ Edwin [mailto:copperwalls@hotmail.com]
Sent: 10 December 2002 17:21
To: Jon Haworth; 'Diana Castillo'
Cc: php-general@lists.php.net
Subject: Re: [PHP] run query
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