Thanks, but I'm still stuck! on a page using mysql how do I use the query you gave me in a page? this is my code now but it wont show the total groundballs, how do I make it add up the sum of all the rows then output it onto the page for me?
<?php $db = mysql_connect("db", "****", "***"); mysql_select_db("net3dual_lax",$db); $search = mysql_query("SELECT SUM(groundballs) FROM rahs"); while($num=mysql_fetch_array($search)) { printf ("Total groundballs: %s",$num["groundballs"]); } ?> Thanks! -------------------------------------------- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Alex Behrens" <[EMAIL PROTECTED]> Sent: Saturday, March 02, 2002 4:58 PM Subject: Re: adding up row values.... > SELECT SUM(groundballs), SUM(shots) FROM table_name; > Also check out this: > SELECT SUM(groundballs), SUM(shots) FROM table_name GROUP BY team; > > On Sat, 2 Mar 2002 16:33:08 -0600, Alex Behrens said: > > > Hey Guys & Gals, > > > > I'm rather new to mysql and need some help accomplishing a command for my > > site: > > > > I am looking to take a column in my table and add all the values, they are > > all numerical. how do I do this? Below is an example of my table: > > > > +-----------------+--------+------+---------+-------------+-------+--------- > > -----+---------------+------------+ > > | name | number | team | penalty | groundballs | shots | > > faceoffs_won | faceoffs_lost | date | > > +-----------------+--------+------+---------+-------------+-------+--------- > > -----+---------------+------------+ > > | pete nelson | 29 | V | none | 7 | 17 | > > 4 | 3 | 2002-03-01 | > > | darrenolson | 91 | V | none | 13 | 32 | > > 2 | 1 | 2002-03-02 | > > | vanguildertest4 | 17 | V | none | 5 | 15 | > > 1 | 1 | 2002-03-01 | > > +-----------------+--------+------+---------+-------------+-------+--------- > > -----+---------------+------------+ > > > > I want to add all of the values for the groundballs, shots, and faceoffs, > > how do I make it add up row values? > > > > Thanks! > > -------------------------------------------- > > -Alex "Big Al" Behrens > > E-mail: [EMAIL PROTECTED] > > Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) > > Phone: 651-482-8779 > > Cell: 651-329-4187 > > Fax: 651-482-1391 > > ICQ: 3969599 > > Owner of the 3D-Unlimited Network: > > http://www.3d-unlimited.com > > Send News: > > [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > -- > ~~~~~~~~~~~~~~ > Ray B. Morris > [EMAIL PROTECTED] > http://www.webmastersguide.com > > Copyright 2002 Morris, All rights reserved > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php