Re: Need to get total number from query!
| From: | Joe Stump | Date: | Fri, 15 Dec 2000 06:38:15 +0000 |
| Subject: | Re: Need to get total number from query! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-30458@lists.php.net to get a copy of this message | ||
@mysql_num_rows($result) ???
--Joe
On Thu, Dec 14, 2000 at 10:24:19PM -0800, Sandeep Hundal wrote:
> Just a quick question. I have a query as such:
> SELECT q9 AS names, count(*) AS numbers FROM table GROUP BY q9 ORDER
> by names desc;
>
> this gives me something like:
> ------------------------
> ans1 : 10
> ans2 : 20
> ans3 : 30
> ------------------------
>
> what i would like is a way to get the total of those 3 figures as a
> variable and plug that in at the bottom... is there a quick way?
>
> thanks!
>
> Sunny
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Shopping - Thousands of Stores. Millions of Products.
> http://shopping.yahoo.com/
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
---
Joe Stump
PHP Programmer
www.Care2.com