[Resolved] record addition

[tuf-web_co_uk]

i'm trying to get the sum of all the records (dl field) amd display it all on a page

eg.

File 1 | 20
File 2 | 13
File 3 | 40

the output in the broswer would be 73

how do i add all the dl fields together and output them?!

thanks

Comms 😉

[zingbats]

DO u mean file sizes? Or values?

$total = $file1 + $file2 + $file3

[tuf-web_co_uk]

neither

in my mysql table

CREATE TABLE polyphonics (
id bigint(20) NOT NULL auto_increment,
make text NOT NULL,
letter text NOT NULL,
name text NOT NULL,
url text NOT NULL,
dl bigint(20) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM ;

i want to collect all of the dl fields from each record and add them together

[stolzyboy]

$query = "select sum(dl) as count_dl;";
$result = mysql_query($query) or die(mysql_error());

$row = mysql_fetch_array($result);

echo $row['count_dl'];

[tuf-web_co_uk]

you missed 'from polyphonics' :p
works now though thanks stolzy 😉

[stolzyboy]

Originally posted by tuf-web.co.uk
you missed 'from polyphonics' :p
works now though thanks stolzy 😉

sorry was in a hurry for some reason

[tuf-web_co_uk]

no probs, you solved the problem anyway 😉