$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']."<BR>\n";

-----Original Message-----
From: Mark Weber [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 12:50 AM
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
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

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]

Reply via email to