Re: adding up row values....

2002-03-02 Thread DL Neil
Alex, > 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? > > $db = mysql_connect("db", "", "*

Fw: adding up row values....

2002-03-02 Thread DL Neil
Spambusting: MySQL > Hey Alex, > > > 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: > > > > > +-++--+-+-+---+- > > > -+

Re: adding up row values....

2002-03-02 Thread Alex Behrens
s" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, March 02, 2002 5:22 PM Subject: Re: adding up row values > Hey Alex, > > > I am looking to take a column in my table and add all the values, they > are >

Re: adding up row values....

2002-03-02 Thread Alex Behrens
sage - 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

adding up row values....

2002-03-02 Thread Alex Behrens
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: +-++--+-+