Re: Need to get total number from query!
| From: | Sandeep Hundal | Date: | Fri, 15 Dec 2000 06:45:57 +0000 |
| Subject: | Re: Need to get total number from query! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-30462@lists.php.net to get a copy of this message | ||
No, that only gives me "3", which is the number of rows actually
returned..... i need a sum of the answers basically... the oens on
the right.
--- Joe Stump <joe@earth.care2.com> wrote: > @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
>
>
> --
> 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
>
__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/