$query = "SELECT sum(my_column) AS total FROM mytable WHERE some_condition";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
print "Sum of my_column is: ".$row['total']."\n";
-Original Message-
From: Mark Weber [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 12:50 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Display results of SUM of an colomn
Hello Everybody,
I'am a new php and mysql user, I have already build a database with 4
coloms.
Now I want to display the sum of all values of 1 of these coloms, I want to
display it within PHP.
Has anyone an example how to display an result of 1 colom, I can't get it
work.
With kind regards,
Mark Weber
Email Thuis: [EMAIL PROTECTED]
Homepage: http://www.knotwilgen.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]