Sum Column in Table

[Anon]

Can someone please tell me how i can sum the total of a column in a table in one of my databases and output the final number ?

[[deleted]]

SELECT SUM(column) FROM table

[Anon]

And how would i echo this to a php file ?

[[deleted]]

Well, you would need to use mysql_query to run the query, mysql_connect to connect to the database, and mysql_result to grab the result of the query....

Matt Wade
http://codewalkers.com

[Anon]

<?
#connect to the server and select db
mysql_connect("localhost","root","redneck");
mysql_select_db("bpashop");

#query the db
$query = "SELECT SUM(final_price) FROM orders_products";
$result = mysql_query($query)
or die(mysql_error());

#display results
while($i = mysql_fetch_row($result)) {
echo $i[0];
echo $i[1];
}
?>
will this work ?