Getting the SUM of a colum

[aquilla]

I've been asked to create a database for our local sports team which holds various bits of data about our players. One of the columns in the database is a total figure which is gained by adding $x + $y. I want to now output the sum of this column to a webpage.

When I do:

SELECT SUM(Series) FROM tablename;

in MySQL I get the extact result, how ever I can't quite make this work with PHP.

Any pointers would be a great help,

Thanks

Stuart

[diego25]

After you run your query through mysql_query(), and called mysql_fetch_array(), your field should be accessed like so:

$row['SUM(Series)']

Diego

[girishn]

Hi,

You can use
SELECT SUM(series) AS total FROM tablename;

and then access it using the aliased name of total

this makes life better

Cheers!