Re: Need to get total number from query!
| From: | Sandeep Hundal | Date: | Sat, 16 Dec 2000 01:28:16 +0000 |
| Subject: | Re: Need to get total number from query! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-30635@lists.php.net to get a copy of this message | ||
there isn't a limit in there either :(
the entire query goes like this:
SELECT q9 AS names, count(*) AS numbers FROM table GROUP BY q9 ORDER
by names desc;
/sunny
--- Joe Stump <joe@earth.care2.com> wrote: > Take your limit off of
the query if there is one.
>
> --Joe
>
> On Thu, Dec 14, 2000 at 10:45:57PM -0800, Sandeep Hundal wrote:
> > 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/
>
> ---
> Joe Stump
> PHP Programmer
> www.Care2.com
>
__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/