Re: Need to get total number from query!

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